Choose Skin

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



Manish Kumar
Computer

SELECT * 
FROM  INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_CATALOG = 'Database_Name'
AND   COLUMN_NAME LIKE '%Column_name%'