Tuesday, 31 January 2017

Is it possible that I can query for names of all tables which contain column with name

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


Refer:  http://stackoverflow.com/questions/4849652/find-all-tables-containing-column-with-specified-name 

1 comment:

Tweets by @sriramperumalla