Technical Article

Finding a particular column in All tables

,

The script can be used to find all the tables that have the particular column name in it.

select a.name from sysobjects  a  inner join syscolumns b
on 
a.id=b.id and b.name ='fk_moduleid'
AND A.XTYPE='U'

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating