Recent Posts

Tuesday, July 22, 2008

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 column
at 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' )

Related Posts by Categories

No comments:

Post a Comment