Find table from column name in sql

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

5 votes356 views1 answer
Sql integer to serial
SQL
0 vote322 views1 answer
Update using case in mysql
SQL
0 vote348 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
2 votes347 views2 answers
Sqlalchemy filter or
SQL
1 vote339 views1 answer
How to unlock table in mysql
SQL
5 votes349 views3 answers
Db begintransaction laravel
SQL
103 votes548 views1 answer
Like sql
SQL
1 vote341 views1 answer
Sql pick random row
SQL
1 vote356 views1 answer
Table valued functions in sql
SQL
14 votes327 views1 answer
Excel is not a database
SQL