How to find a table...  
Author Message
Franky88





PostPosted: Tue Sep 13 10:09:21 CDT 2005 Top

SQL Server Developer >> How to find a table...

Hi all,

I have a large database with many tables created by a 3rd party vendor.
I would like to be able to find which table a field belongs to without
searching through every single table. Is there some tool out there to
enable such a search?

Thanks

SQL Server278  
 
 
Jens





PostPosted: Tue Sep 13 10:09:21 CDT 2005 Top

SQL Server Developer >> How to find a table... Select * from INFORMATION_SCHEMA.COLUMNS Where Column_Name like
'<YourColumnName>'

HTH, Jens Suessmeyer.

 
 
Aaron





PostPosted: Tue Sep 13 10:10:18 CDT 2005 Top

SQL Server Developer >> How to find a table... To find all occurences of a *column* named "foo" use

SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME='foo'





> Hi all,
>
> I have a large database with many tables created by a 3rd party vendor.
> I would like to be able to find which table a field belongs to without
> searching through every single table. Is there some tool out there to
> enable such a search?
>
> Thanks
>


 
 
Narayana





PostPosted: Tue Sep 13 10:11:02 CDT 2005 Top

SQL Server Developer >> How to find a table... Here's an example, that searches for tables with a column name of 'Alias':

SELECT TABLE_SCHEMA AS TableOwner, TABLE_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME = 'Alias'
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/




Hi all,

I have a large database with many tables created by a 3rd party vendor.
I would like to be able to find which table a field belongs to without
searching through every single table. Is there some tool out there to
enable such a search?

Thanks


 
 
JT





PostPosted: Tue Sep 13 11:00:27 CDT 2005 Top

SQL Server Developer >> How to find a table... There is a feature in Query Analyzer for searching objects across a server
by name and/or object type. Look under the menu option Tools.. Object
Search.. New..



> Hi all,
>
> I have a large database with many tables created by a 3rd party vendor.
> I would like to be able to find which table a field belongs to without
> searching through every single table. Is there some tool out there to
> enable such a search?
>
> Thanks
>


 
 
kishor





PostPosted: Wed Sep 14 00:37:03 CDT 2005 Top

SQL Server Developer >> How to find a table... hi,
All replies to this will solve the problem ... no doubt about this.
There is one interesting tool to perform such activities more in advance
SQLcompare...from redgate.

thanxs
Kishor







> Hi all,
>
> I have a large database with many tables created by a 3rd party vendor.
> I would like to be able to find which table a field belongs to without
> searching through every single table. Is there some tool out there to
> enable such a search?
>
> Thanks
>
>