MS SQL Find A Table
-- Find Table By Name
SELECT *
FROM sys.tables
WHERE name LIKE '%request%';
-- Find Table From All Databases By Name
EXEC sys.sp_MSforeachdb
'SELECT ''?'' DatabaseName, Name
FROM [?].sys.Tables
WHERE Name
LIKE ''%request%''';
-- Find Table By ColumnName
SELECT sys.tables.name AS 'TableName',
sys.tables.object_id AS 'ObjectID',
sys.columns.name AS 'ColumnName'
FROM sys.tables
INNER JOIN sys.columns
ON sys.tables.object_id = sys.columns.object_id
WHERE sys.columns.name LIKE '%request%'
ORDER BY 1;
-- Find Table By ColumnName 2
SELECT OBJECT_NAME(object_id) AS 'TableName',
object_id,
name AS 'ColumnName'
FROM sys.columns
WHERE name LIKE '%request%';