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 2000 Forums
 SQL Server Development (2000)
 finding a column name in a SQL 2000 database

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-04-28 : 14:10:06
Gary writes "I am a novice with SQL, but I need to find any column with 'sig' in it's name. The database I'm searching has 84 tables and googles of columns in each table.

What script would I use in SQL 2000?

I have tried books on line and on line forums with no success

Thanks for your help."

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2004-04-28 : 14:10:06
I'd use the information schema tables: http://www.sqlteam.com/item.asp?ItemID=13122. Specfically the ones for columns.
Go to Top of Page
   

- Advertisement -