The computer has come to shape our world and the universe. It is so important that we cannot do without this fantastic invention. You would have heard about networking before. Networking is all about connection, the concept of networking can be applied to every facet of human life. It refers to a computer as well.

Find all tables containing column with specified name.

Anil

Find all tables containing column with specified name

Many developers asking is it possible to find a column name in all tables which has columns specified name. So here is query to search a column in a SQL Server database.

Search in all tables

SELECT c.name AS 'Column', 
t.name AS 'TableName'
FROM sys.columns c
JOIN sys.tables  t   ON c.object_id = t.object_id
WHERE c.name = 'MycolumnName' --specify search column name
ORDER BY TableName,Column

Search in all tables and views

SELECT COLUMN_NAME AS 'Column',
TABLE_NAME AS 'TableName'
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'MyColumnName' --specify search column name
ORDER BY TableName,Column;