Posted by Mike on 10/20/05 22:36

"corey lawson" <corey.lawson@ayeteatea.net> wrote in message
news:11lfjta387n38ae@corp.supernews.com...
> 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
>

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

[Back to original message]