SQL Script To Find For A Particular Column In A Database

,

Just run the script by providing the apt column name to be searched in a particular DB this is a small script but helps a lot...!!!!

SELECT so.name as tablename, sc.name as columnname from sysobjects so

JOIN syscolumns sc

on sc.id = so.id and sc.name like '<<Column Name>>'

and so.xtype = 'U'

Rate

2.5 (4)

Share

Share

Rate

2.5 (4)