searching for column names

microsoft.public.sqlserver.tools

5 Nov 2007 3:24 PM

andy

I was able to search for column names (among many other things) in SQL
Server 2000 when I was in a query view. Is there a way to search by a
column name in database in 2005?

Thanks.

5 Nov 2007 4:09 PM

Russell Fields

Andy,

In SQL Server 2005 there is the new catalog view sys.columns. Also, the
INFORMATION_SCHEME.COLUMNS view is supported in 2000 and 2005.

RLF

Show quote

"andy" <ajgo***@longlines.com> wrote in message
news:%23WT3y$7HIHA.4688@TK2MSFTNGP06.phx.gbl...
>I was able to search for column names (among many other things) in SQL
>Server 2000 when I was in a query view. Is there a way to search by a
>column name in database in 2005?
>
> Thanks.
>