Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to search column name ?

Author  Topic 

jeff06
Posting Yak Master

166 Posts

Posted - 2009-03-31 : 10:44:25
I know use sql sever analyser to search column name in tables.
I can not figure out how search column name by using management studio.
Can someone kindly help me out with this?
Thanks.
Jeff

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-03-31 : 12:06:31
select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS
Go to Top of Page

SSISJoost
Starting Member

9 Posts

Posted - 2011-01-26 : 01:48:03
I use this query:
[url]http://microsoft-ssis.blogspot.com/2011/01/search-for-columnname.html[/url]
Go to Top of Page
   

- Advertisement -