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
 Development Tools
 ASP.NET
 Identifying table by column name with query

Author  Topic 

Swati Jain
Posting Yak Master

139 Posts

Posted - 2007-06-13 : 07:48:42
If i know the column name
how to identify that column is in which table in huge database?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-06-13 : 07:56:51
select * from information_schema.columns

you can figure out the rest.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -