D. Patrick Hoerter
03-19-2000, 12:05 AM
Mike,
If you have SQL 7.0, then query the INFORMATION_SCHEMA.COLUMNS view. It
has everything you need. Try not to query system tables directly - you might
pay for it later when MS decides to re-engineer them.
Regards,
D. Patrick Hoerter
Mike wrote in message <38c76290$1@news.devx.com>...
>
>Is there any way, either in Enterprise Manager, or
>T-SQL to search for a column name in all tables of
>a database? Does the system database hold this somewhere?
>Can I query the System database for it? Beginner needs
>some help here.
>
If you have SQL 7.0, then query the INFORMATION_SCHEMA.COLUMNS view. It
has everything you need. Try not to query system tables directly - you might
pay for it later when MS decides to re-engineer them.
Regards,
D. Patrick Hoerter
Mike wrote in message <38c76290$1@news.devx.com>...
>
>Is there any way, either in Enterprise Manager, or
>T-SQL to search for a column name in all tables of
>a database? Does the system database hold this somewhere?
>Can I query the System database for it? Beginner needs
>some help here.
>