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 vote258 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote226 views1 answer
Get foreign table names mysql
SQL
1 vote246 views1 answer
Mysql size int
SQL
1 vote236 views1 answer
Postgres convert exisiting column to text
SQL
0 vote243 views3 answers
Insert query in ci
SQL
3 votes259 views2 answers
How to force truncate a table in mysql
SQL
0 vote244 views1 answer
Mysql update set sum
SQL
0 vote243 views1 answer
Postgres meta command to show all rows in table
SQL
0 vote224 views2 answers
Mysql slave status
SQL
0 vote232 views1 answer
How to connect postgresql database with java
SQL