/SQL/Sql server search column name in all tables

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

11 votes227 views3 answers
Change column name sql server management studio
SQL
0 vote179 views2 answers
Jupyter notebook connect to database
SQL
0 vote215 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
11 votes222 views2 answers
Import sql file laravel cmd
SQL
7 votes208 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote266 views2 answers
Mysql cast to varchar
SQL
0 vote239 views1 answer
Import Data in MySQL without using any other software
SQL
0 vote260 views1 answer
Mysql get nested records
SQL
6 votes255 views6 answers
Rename column postgres
SQL
0 vote218 views1 answer
Implicit inner join table alias with id values
SQL