Tech Blog

Since 2004

Read Article

SQL Server and Find all Columns in a Database


Find all occurrences of the column in any object.

- April 20, 2015

Rest of the Story:

Where the column name matches exactly…

SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns
WHERE name = '{text}' )
Where the column name is like…
SELECT name FROM sysobjects WHERE id IN 
    ( SELECT id FROM syscolumns WHERE name like '%{text}%' )

The following will show all occurrences of the column in any object
SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME LIKE '%doctorid%'

sql sqlserver
SharePoint 2010 Iterating Sites–COM Factory Error .NET 3.5 SP1 How to tell if it is installed?