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 vote130 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
0 vote78 views1 answer
Mysql timeout 30 seconds
SQL
0 vote113 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote126 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote114 views1 answer
Dump multiple tables mysql
SQL
1 vote108 views1 answer
PLS-00225 type
SQL
0 vote68 views1 answer
Mariadb list tables
SQL
0 vote111 views1 answer
Arithmetic expression in sql
SQL
5 votes120 views1 answer
Sql table columns
SQL
0 vote126 views1 answer
Difference between min and max date sql
SQL