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 vote111 views1 answer
Get substract count sql
SQL
0 vote100 views1 answer
Regex any word except sql
SQL
0 vote101 views1 answer
Mysql 5.7 in centos 7
SQL
3 votes99 views5 answers
Mysql get last inserted id
SQL
0 vote104 views1 answer
Grant privileges of databse to user
SQL
0 vote119 views1 answer
Python sqlalchemy connection show server
SQL
0 vote146 views1 answer
Uncaught PDOException: SQLSTATE[HY000] [1698]
SQL
0 vote114 views1 answer
PGSQL dynamic table name
SQL
0 vote116 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
0 vote112 views1 answer
Java check if something is in mysql table
SQL