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

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

Sql server search column name in all tables

SELECT      COLUMN_NAME AS 'ColumnName'
            ,TABLE_NAME AS  'TableName'
FROM        INFORMATION_SCHEMA.COLUMNS
WHERE       COLUMN_NAME LIKE '%MyName%'
ORDER BY    TableName
            ,ColumnName;

Source: stackoverflow.com

Get all tables with column name 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

Similar codes

0 vote195 views1 answer
Set column in all row mysql
SQL
6 votes214 views2 answers
Foreign key sqlite3 python
SQL
0 vote202 views1 answer
T sql return on letters only
SQL
6 votes220 views2 answers
Oracle undotbs usage
SQL
7 votes201 views3 answers
Sql update where id
SQL
1 vote227 views1 answer
Sql group by sum with condition
SQL
1 vote211 views2 answers
Sql server concat string and int
SQL
0 vote247 views1 answer
Grouping by email domain mysql
SQL
0 vote210 views1 answer
Sql recherche nom prenom
SQL
0 vote232 views1 answer
Sql show founctions
SQL