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 vote323 views2 answers
Php convert dbf to mysql
SQL
0 vote314 views1 answer
Postgresql import data from csv
SQL
0 vote368 views1 answer
Gcloud sql instance list
SQL
104 votes546 views2 answers
Like in mysql
SQL
7 votes352 views3 answers
Add primary key to database sql
SQL
0 vote328 views2 answers
How to list all values of a column that start with a letter in sql
SQL
11 votes330 views2 answers
Set default column value sql
SQL
0 vote328 views1 answer
FIND AVERAGE SALARY EARNER IN SQL
SQL
5 votes335 views1 answer
How to check nls format in oracle
SQL
1 vote319 views1 answer
Primary key reset in SQL database
SQL