|
|
|
Author |
Message |
Franky88
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
|
Posted: 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
>
>
|
|
|
|
|
|
|