1SELECT COLUMN_NAME AS 'ColumnName'
2 ,TABLE_NAME AS 'TableName'
3FROM INFORMATION_SCHEMA.COLUMNS
4WHERE COLUMN_NAME LIKE '%MyName%'
5ORDER BY TableName
6 ,ColumnName;
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;
1BY LOVE SINGH
2
3SELECT TABLE_NAME
4FROM INFORMATION_SCHEMA.TABLES
5WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_CATALOG='YOUR_Database_name'
1SELECT * FROM USER_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- Connected user
2SELECT * FROM ALL_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- Other schemas
3SELECT * FROM DBA_TAB_COLUMNS WHERE COLUMN_NAME = 'MY_COLUMN'; -- All tables