Find table for 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

Search for column name in sql db when i don't know which table it is in

Select * from  INFORMATION_SCHEMA.COLUMNS
where COLUMN_NAME LIKE '%MyName%'

Source: stackoverflow.com

Search column name sql

SELECT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%wild%';

Source: stackoverflow.com

Similar codes

0 vote277 views1 answer
FIND most frequent word in sql server
SQL
3 votes221 views1 answer
Oracle user quota unlimited
SQL
0 vote230 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
0 vote216 views1 answer
Sql examples from your work
SQL
18 votes239 views6 answers
Create table mysql
SQL
1 vote263 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote238 views1 answer
Sql select with apostrohpe
SQL
12 votes238 views4 answers
How to take database dump in postgresql
SQL
11 votes242 views1 answer
Sql query to find duplicates in column
SQL
-1 vote235 views2 answers
Postgresql get last 10 records
SQL