Find that Column

July 2nd, 2009
Goto comments Leave a comment

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%')

All Things Data, Basic Series, Data Warehouse, Tips and Tricks

  1. No comments yet.
  1. No trackbacks yet.