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

0 vote220 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote166 views1 answer
Mysql select all where count more than"
SQL
1 vote164 views1 answer
Oracle lock user
SQL
0 vote175 views1 answer
Pl sql round
SQL
6 votes167 views1 answer
Update left join mysql
SQL
4 votes168 views1 answer
Wildcard in sql
SQL
0 vote168 views1 answer
Kotlin sqlite delete row
SQL
0 vote176 views1 answer
Migrations.RunSQL
SQL
16 votes182 views4 answers
Mysql import from sql file
SQL
1 vote182 views1 answer
Mysql show attributes of a table
SQL