System Catalog export

23 Apr 2007 6:52 PM

AJ

Hello,

I'm looking for a way to extract system catalog information from out
databases to an external source (Excel or Visio). Is there a built in
procedure for this in SQL 2000? Or do I need to run schema view and then copy
and paste the information.

24 Apr 2007 4:32 AM

Hari Prasad

Hello,

You may need to query the Information Schema view or system tables and
redirect the output to a file.

Thanks
Hari

Show quote

"AJ" <A*@discussions.microsoft.com> wrote in message
news:2A11BABB-A558-4DEB-86C2-C0F540A983F4@microsoft.com...
> Hello,
>
> I'm looking for a way to extract system catalog information from out
> databases to an external source (Excel or Visio). Is there a built in
> procedure for this in SQL 2000? Or do I need to run schema view and then
> copy
> and paste the information.
>
>