Find column name match in tables
SELECT sys.Tables.NAME AS TableName
,sys.columns.NAME AS ColumnName
FROM sys.columns
INNER JOIN
sys.Tables ON sys.Tables.object_id = sys.columns.object_id
WHERE sys.columns.NAME LIKE '<<Column Name>>'
No comments:
Post a Comment
Thank you for your interest .