Find column name in database

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

Find column name in database

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 '%columnName%'
ORDER BY    TableName
            ,ColumnName;

Similar codes

6 votes337 views3 answers
Oracle all dates between two dates
SQL
1 vote338 views1 answer
Where database run
SQL
24 votes329 views4 answers
Postgres remove database
SQL
0 vote278 views1 answer
Now() -1 mysql
SQL
0 vote336 views1 answer
Cross apply top for each row t1
SQL
9 votes320 views4 answers
Last mysql
SQL
2 votes270 views1 answer
Sql group by different columns
SQL
28 votes332 views6 answers
Mysql change user password
SQL
0 vote332 views2 answers
Select columns from 2 tables with foreign key
SQL
0 vote327 views1 answer
Permission denied postgres \copy csv command line
SQL