zaagan
1/5/2020 - 11:39 AM

MS SQL Find A Table

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%';