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

0 vote249 views1 answer
Order by with where clause in mysql
SQL
2 votes260 views1 answer
Mariadb JSON_EXTRACT
SQL
5 votes261 views2 answers
Oracle apex debug mode
SQL
5 votes246 views1 answer
Oracle columns in all_tables
SQL
0 vote276 views2 answers
Postgresql gset
SQL
1 vote260 views1 answer
Mysql batch insert
SQL
1 vote261 views1 answer
Get last week data in mysql
SQL
0 vote282 views1 answer
How to find all children of a record with only parent ID in sql
SQL
6 votes262 views2 answers
Oracle
SQL
0 vote245 views1 answer
Dasebase_url-postgres for windows
SQL