SQL Server: Find table.column where column name is LIKE x

Revision: 7890

at August 19, 2008 14:50 by tclancy

Initial Code

SELECT sc.[name] as column_name, so.[name] as table 
FROM syscolumns sc 
INNER JOIN sysobjects so ON sc.id=so.id 
WHERE sc.[name] LIKE '%x%'

Initial URL

Initial Description

Initial Title

SQL Server: Find table.column where column name is LIKE x

Initial Tags

Initial Language

SQL