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;

Contribute AnotherBraket Forum

Rathnakar

At AnotherBraket, we welcome QA on sysadmin, database and programming. We work hard to grow AnotherBraket as many great QA as possible. We are interested in publishing QA that will be relevant today, next year and even beyond. This is the reason why we have certain editorial standards that must be followed by programming when submitting QA for us. when submitting an QA on anotherbraket.com, the following criteria should be kept..