Monday, November 30, 2009

Search a specific column in Sql Server Database

To find a specific column in a huge database system is pretty hectic and you miss out the columnat all sometimes and later decide to give it up or trapped in some hectic process. Therefore to get a better solution to this just try this query and it will show you the tables where to look at for that specific column:
SELECT name FROM sysobjects WHERE id IN ( SELECT id FROM syscolumns WHERE name = 'ColumnName' )

No comments:

Post a Comment