Friday, February 10, 2012

To check column name in a database

If you know column name but to find out which table has that
Do this:
Select Name from sysobjects where id in (select id from syscolumns where name like '%userid%')

No comments:

Post a Comment