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

7 votes195 views1 answer
Set sequence value oracle
SQL
0 vote192 views1 answer
Check if database exists sql
SQL
0 vote176 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote148 views0 answer
SQL
0 vote191 views1 answer
If null don't update
SQL
0 vote196 views1 answer
How to join result table in mysql
SQL
0 vote178 views1 answer
Get number of table colums in sql query
SQL
6 votes194 views4 answers
Mysql group by date
SQL
8 votes187 views1 answer
Sql remove leading spaces
SQL
0 vote189 views1 answer
Sqlite higher or equal
SQL