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

1 vote183 views1 answer
GROUP BY clause; this is incompati
SQL
1 vote180 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote235 views1 answer
Python mysql executemany
SQL
0 vote183 views1 answer
Mysql add to number
SQL
0 vote209 views1 answer
C# sql transaction multiple connections
SQL
3 votes191 views1 answer
Oracle get trigger ddl
SQL
5 votes208 views5 answers
Find max number in sql
SQL
0 vote184 views1 answer
Not equal to blank in mysql
SQL
15 votes182 views2 answers
Select Options
SQL
3 votes181 views1 answer
Two select sql
SQL