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 vote332 views3 answers
Characters found after end of sql statement
SQL
1 vote277 views2 answers
Update with inner join sql server
SQL
0 vote300 views2 answers
Drop tables from local table database postgres
SQL
0 vote237 views1 answer
Oracle sql developer script output limit
SQL
1 vote284 views2 answers
Change table name phpmyadmin
SQL
0 vote245 views1 answer
Sql new line output
SQL
9 votes302 views6 answers
Oracle substring
SQL
9 votes291 views2 answers
Sql server check table exists
SQL
0 vote280 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote299 views1 answer
Copy data from one postgres container to another
SQL