Find table names with column name?

Question

How can I get all the table names where the column name is indicated? I need names with "Like" in the sql server. For example: -

select TableNames where columnname like '%MyColumn%' 

Please help me

Answer 1

Try the query below. Use sys.columns for information: -

 SELECT c.name AS ColName, t.name AS TableName FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%MyCol%'; 

Answer 2

You can do it:

 SELECT t.name AS table_name, SCHEMA_NAME(schema_id) AS schema_name, c.name AS column_name FROM sys.tables AS t INNER JOIN sys.columns c ON t.OBJECT_ID = c.OBJECT_ID WHERE c.name LIKE '%MyColumn%' ORDER BY schema_name, table_name; 

Link:

• SQL SERVER - query to find a column from all database tables

Answer 3

Try it like this: For SQL SERVER 2008 +

 SELECT c.name AS ColName, t.name AS TableName FROM sys.columns c JOIN sys.tables t ON c.object_id = t.object_id WHERE c.name LIKE '%MyColumnaName%' 

Or

 SELECT COLUMN_NAME, TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%MyName%' 

Or Something like this:

 SELECT name FROM sys.tables WHERE OBJECT_ID IN ( SELECT id FROM syscolumns WHERE name like '%COlName%' )