Find all table names with column name

Question

How can I get all the table names where the given column name exists  I want the names with  Like  in sql server  For example  -    select TableNames where columnname like   MyColumn     Please help me

User · Accepted Answer

Please try the below query  Use sys columns to get the details  -  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

User · Answer

Try 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

User · Answer

You could do this   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    Reference    SQL SERVER     Query to Find Column From All Tables of Database

[sql-server] Find all table names with column name?

Examples related to sql-server