Jul 25th, 2009 | No Comments

Here is the query that will help you to find a particular column in the database. This query will return you the table name in which that column is found.

select so.name, sc.name
from syscolumns sc
inner join sysobjects so on sc.id = so.id
where sc.name = 'SystemColumn'

Written by Ajay Matharu

July 25th, 2009 at 12:03 pm