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 votes122 views2 answers
Postgresql insert select
SQL
7 votes124 views2 answers
Where keyword sql
SQL
1 vote61 views1 answer
Alter user mysql native password
SQL
7 votes124 views1 answer
Return insert results in POSTGRESQL
SQL
0 vote129 views1 answer
Selecting all columns from table sql database
SQL
0 vote98 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
32 votes108 views6 answers
Insert select
SQL
3 votes108 views2 answers
WhereIn SQL
SQL
1 vote109 views1 answer
Count mysql server db tables
SQL
0 vote125 views2 answers
How to install psql in ubuntu
SQL