/SQL/Find all tables containing column with specified name - MS SQL Server

Find all tables containing column with specified name - MS SQL Server

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

Find all tables containing column with specified name - MS SQL Server

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

Similar codes

0 vote141 views1 answer
Count columns psql(PostreSQL)
SQL
0 vote139 views1 answer
Ignore case in string sql
SQL
0 vote186 views1 answer
CONVERT time string into 12 hours in sql
SQL
0 vote141 views1 answer
We are intrested to work with your organization
SQL
1 vote145 views1 answer
How to select rows with no matching entry in another table?
SQL
0 vote143 views1 answer
Mysql trim characters
SQL
0 vote150 views1 answer
How to update date value in sql
SQL
1 vote239 views1 answer
Sql injection
SQL
3 votes167 views3 answers
Order by postgres
SQL
2 votes147 views1 answer
Express api ith mysql data
SQL