object search in SQL Server 2005 1

[stanja]

Hello ,

At sql server 2000 you can do in Query analyzer an object search (fe a column name) by the F4 key.
How can i perform this search in SQL server 2005 (server managament studio) ?

tx
grtz

Steven

 

[ptheriault]

If you need to find a column in SQL Server 2005 use the information schema

select *
from information_schema.columns
where column_name = 'ProductID'

- Paul
- Database performance looks fine, it must be the Network!

 

[mrdenny]

You can also use the sys.columns and sys.tables views.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com