1SELECT c.name AS 'ColumnName'
2 ,t.name AS 'TableName'
3FROM sys.columns c
4JOIN sys.tables t ON c.object_id = t.object_id
5WHERE c.name LIKE '%MyName%'
6ORDER BY TableName
7 ,ColumnName;
1SELECT TABLE_NAME
2FROM INFORMATION_SCHEMA.TABLES
3WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'
1BY LOVE SINGH
2
3SELECT TABLE_NAME
4FROM INFORMATION_SCHEMA.TABLES
5WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'