/SQL/Find all tables containing column with specified name - MS SQL Server

Find all tables containing column with specified name - MS SQL Server

Sql server search column name in all tables

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

Source: stackoverflow.com

Find all tables containing column with specified name - MS SQL Server

SELECT      c.name  AS 'ColumnName'
            ,t.name AS 'TableName'
FROM        sys.columns c
JOIN        sys.tables  t   ON c.object_id = t.object_id
WHERE       c.name LIKE '%MyName%'
ORDER BY    TableName
            ,ColumnName;

Source: stackoverflow.com

Similar codes

6 votes213 views2 answers
Sql display max value
SQL
0 vote221 views1 answer
Lesser than or equal to symbol in postgres
SQL
13 votes218 views2 answers
Sql count distinct group by
SQL
45 votes245 views5 answers
Grant all privileges mysql
SQL
0 vote210 views2 answers
2nd max salary query in sql
SQL
5 votes219 views2 answers
Sql server check port number
SQL
-3 votes208 views1 answer
Remove spaces sql 2008
SQL
0 vote173 views1 answer
Sql select rows with simlar names
SQL
0 vote213 views1 answer
Oracle date summer time
SQL
0 vote175 views1 answer
Update row in sqlite python
SQL