Re: SQL Server 2000 Table Properties

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 10:48:05 -0500

You should find Books Online within your SQL Server program group. It is
the documentation that ships with SQL Server.

You can download the latest and greatest version from here:
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

If you want to use a web interface:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/startsql/getstart_4fht.asp 

-- 
Keith
"Evin" <evin.conway@hypointernational.com> wrote in message
news:0b2101c4967d$52bdb7e0$a401280a@phx.gbl...
> Keith,
>
> Cheers for that. I couldn't find the where the Books
> Online is, (do you have a link to it anyway?). But was
> able to find out about the INFORMATION_SCHEMA views, run
> that query, (Select * FROM INFORMATION_SCHEMA.columns),
> gives me exactly what I needed and a bit more.
> Thanks for sending the answer so quickly.
>
> Appreciated.
>
> Evin
>
> >-----Original Message-----
> >Read about the INFORMATION_SCHEMA views within Books
> Online.  The views
> >contain lots of great information that I am sure you
> will find helpful.
> >
> >-- 
> >Keith
> >
> >
> >"Evin" <evin.conway@hypointernational.com> wrote in
> message
> >news:8c9101c49678$8d3a32e0$a601280a@phx.gbl...
> >> Does anyone know of a way to export a list of table
> >> properties in SQL Server 2000 please, or a tool I can
> >> download to do the job? There is a database with 100+
> >> tables, and I want to download all table properties,
> >> (including Column Name, Data Type, Length, Allow
> Nulls),
> >> so that I can document it.
> >> I started to open the properties of each table and copy
> >> the details into a spread***, although that might
> take
> >> awhile.
> >>
> >> Any ideas? Email if you can please.
> >>
> >> Thanks!
> >
> >.
> >
Quantcast