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

14 votes216 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote214 views1 answer
Check if record exists mysql
SQL
0 vote213 views1 answer
Mysql add root password
SQL
38 votes249 views6 answers
Ubuntu install mysql client
SQL
4 votes207 views2 answers
DB::transaction
SQL
2 votes219 views1 answer
Oracle calculated column
SQL
2 votes208 views1 answer
Oracle log files
SQL
1 vote213 views1 answer
User privileges postgresql information_schema
SQL
1 vote213 views1 answer
Deleting database in sql
SQL
0 vote205 views1 answer
Stop psql server windows
SQL