Archive

Posts Tagged ‘SQL Column Search’

Find that Column

July 2nd, 2009 No comments

How to find that elusive column in your SQL server.

Tip of The Day:

SELECT
name
FROM
sysobjects
WHERE
id IN (SELECT id FROM syscolumns WHERE name like '%COLUMN_NAME%')

Categories: All Things Data, Basic Series, Data Warehouse, Tips and Tricks Tags: