Table Documentor

I am sort of new to SQL. I use MS-Access most of the time so I do not know
if you can do this, but...

In MS-Access there was a tool called documenter that would list out the
table def's such as fields, sizes, data types, etc. Is there such a thing in
SQL?

I am using MS-SQL 2000 server.

Mike
m charney at dunlap hospital dot org

Mike wrote:

> I am sort of new to SQL. I use MS-Access most of the time so I do not know
> if you can do this, but...
>
> In MS-Access there was a tool called documenter that would list out the
> table def's such as fields, sizes, data types, etc. Is there such a thing 
in
> SQL?
>
> I am using MS-SQL 2000 server.
>
> Mike
> m charney at dunlap hospital dot org
>
>

Check out the various INFORMATION_SCHEMA views, i.e., select * from
INFORMATION_SCHEMA.TABLES

"corey lawson" <corey.lawson@ayeteatea.net> wrote in message
 news:11lfjta387n38ae
@corp.supernews.com...
> Mike wrote:
> 
>
> Check out the various INFORMATION_SCHEMA views, i.e., select * from
> INFORMATION_SCHEMA.TABLES
>

Using the following:

Select *
From INFORMATION_SCHEMA.TABLES

I only get the the table listings. I dont get the field names, sizes, etc.

How would I get those?

Mike

Mike (noway@forgetit.com)  writes:
> I am sort of new to SQL. I use MS-Access most of the time so I do not know
> if you can do this, but...
>
> In MS-Access there was a tool called documenter that would list out the
> table def's such as fields, sizes, data types, etc. Is there such a
> thing in SQL?
>
> I am using MS-SQL 2000 server.

In Enterprise Manager there are some graphical utilities, you can start
looking for Diagrams.

> Using the following:
>
> Select *
> From INFORMATION_SCHEMA.TABLES
>
> I only get the the table listings. I dont get the field names, sizes, etc.
>
> How would I get those?

These are in INFORMATION_SCHEMA.COLUMNS. The INFORMATION_SCHEMA views
are documented in Books Online.

Personally, I am more fond of using the system tables directly, as
INFORMATION_SCHEMA does not have all information, for instance,
there is no information about indexes.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp