Tuesday, January 22, 2013

SQL Server Query to find all the tables in a database with a specific column name

Following Query return all columns with name 'Col_name'
===============================================

GO
SELECT

t.name AS table_name
,SCHEMA_NAME(schema_id) AS schema_name
,c.name AS column_name
FROM
sys.tables AS t
INNER JOIN sys.columns c
ON t.OBJECT_ID = c.OBJECT_ID
WHERE
c.name LIKE '%Col_name%'
ORDER BY
schema_name
,table_name;