How to print the Table layout

[Fabio Terrosi]

Hello to everyone

I am using SQL Server Enterprise Manager and I would like to print the
structure of each table of a database, with the purpose to see the whole
record layout. (In Access there is Analyzer which does that) but
apparently I acnnot find anything similar in EM.
Who Could help me?

Thank you to everyone!
Regards
Fabio
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Simon Hayes]

"Fabio Terrosi" <ft****@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

Hello to everyone

I am using SQL Server Enterprise Manager and I would like to print the
structure of each table of a database, with the purpose to see the whole
record layout. (In Access there is Analyzer which does that) but
apparently I acnnot find anything similar in EM.
Who Could help me?

Thank you to everyone!
Regards
Fabio
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In EM you can create database diagrams - expand any database and right-click
the diagrams icon. You can right-click tables to select what is displayed or
not for each one. If this doesn't provide what you need, then you would need
to look into third party tools.

Simon

[Scot McDermid]

"Fabio Terrosi" <ft****@hotmail.com> wrote in message
news:41**********************@news.newsgroups.ws.. .

Hello to everyone

I am using SQL Server Enterprise Manager and I would like to print the
structure of each table of a database, with the purpose to see the whole
record layout. (In Access there is Analyzer which does that) but
apparently I acnnot find anything similar in EM.
Who Could help me?

The complete structure of every column, of every table,
can be queried from the system tables.

I'm very rusty on sys tables and my SQL is rusty and
uses the old style but this should work for you:

SELECT sysobjects.name table_name,
syscolumns.name column_name
from sysobjects, syscolumns
where sysobjects.type = 'U'
and syscolumns.id = sysobjects.id
ORDER BY sysobjects.name

[This will return the table name and column name.
If you want the column datatypes then you will
find that in the syscolumns table.]