Find that Column

July 2nd, 2009 Leave a comment Go to 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:
  1. No comments yet.
  1. No trackbacks yet.