|
Home > Archive > Microsoft SQL Server forum > October 2005 > Table Documentor
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
| |
| corey lawson 2005-10-27, 9:25 am |
| 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
| |
| Erland Sommarskog 2005-10-27, 9:25 am |
| 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
|
|
|
|
|