Find that Column

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.