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

4 votes339 views1 answer
Create column mysql terminal
SQL
11 votes343 views2 answers
Safe mode off mysql
SQL
3 votes306 views1 answer
Postgresql where current year
SQL
2 votes342 views1 answer
Drop table if exists in postgres
SQL
2 votes370 views1 answer
Can you use a where clause for a child query
SQL
0 vote343 views1 answer
Postgres in operator with comma separated values
SQL
1 vote355 views1 answer
Duplicating a MySQL table with all the data Command
SQL
4 votes376 views2 answers
Truncate oracle
SQL
0 vote362 views1 answer
Set a default value for a column in sqlite
SQL
7 votes369 views5 answers
Sql remove spaces
SQL