Robert 的部落格

來源:Find all tables containing column with specified name - MS SQL Server - Stack Overflow
 

搜尋所有 Table

SELECT t.name AS 'TableName'
 ,c.name AS 'ColumnName'
FROM sys.columns c
JOIN sys.tables t ON c.object_id = t.object_id
WHERE c.name LIKE '%MyName%'
ORDER BY TableName
 ,ColumnName;

 

搜尋所有 Table, View

SELECT TABLE_NAME AS 'TableName'
 ,COLUMN_NAME AS 'ColumnName'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%MyName%'
ORDER BY TableName
 ,ColumnName;