MS SQL Server Tools - Table design exportation

Author

Table design exportation

Montag

2005-10-27, 7:54 am

Hi everybody

I was looking for a tool that exports the structure of the tables of my
SQL Server database. I've found some, but noone that exports also the
description of the fields in the tables.

Anyone knows about a tool that does it?

giovanni

Keith Wilson [MSFT]

2005-10-27, 7:54 am

SQL Server 2000 SP-4 Enterprise Edition contains a Database Diagram
component.

Once the desired tables and related tables from a database are loaded,
simply launch the context menu (by issuing a right mouse click from any
table) and switching from the default "Column Names" view to the "Standard"
view which displays a table name, column name, the data type of the column,
the length, and whether or not null values are permitted.

Additionally, from the same context menu, you can launch "Modify Custom...".
From the related dialog, you can add more information such as Precision,
Scale, Default Value, Identity, Formula, Collation, Description, ...

Regards,
Keith

This posting is provided "as is" without inferring rights or warranties.

"Montag" < 6050invalid@mynewsga
te.net> wrote in message
news:200510031355266
050@mynewsgate.net...
> Hi everybody
>
> I was looking for a tool that exports the structure of the tables of my
> SQL Server database. I've found some, but noone that exports also the
> description of the fields in the tables.
>
> Anyone knows about a tool that does it?
>
> giovanni
>

Keith Wilson [MSFT]

2005-10-27, 7:54 am

In order to launch the Database Diagram component, perform the following:

Launch Enterprise Manager from the Start > Programs > Microsoft SQL Server
menu
Connect to the server of your choice
Expand the tree view to the database of your choice
Issue a right mouse click on the "Diagram" entry
Select New Database Diagram...

Regards,
Keith

This posting is provided "as is" without inferring rights or warranties.

"Keith Wilson [MSFT]" <Keith.Wilson@online.microsoft.com> wrote in message
news:43442d10$1@news
.microsoft.com...
> SQL Server 2000 SP-4 Enterprise Edition contains a Database Diagram
> component.
>
> Once the desired tables and related tables from a database are loaded,
> simply launch the context menu (by issuing a right mouse click from any
> table) and switching from the default "Column Names" view to the
> "Standard" view which displays a table name, column name, the data type of
> the column, the length, and whether or not null values are permitted.
>
> Additionally, from the same context menu, you can launch "Modify
> Custom...". From the related dialog, you can add more information such as
> Precision, Scale, Default Value, Identity, Formula, Collation,
> Description, ...
>
> Regards,
> Keith
>
> This posting is provided "as is" without inferring rights or warranties.
>
> "Montag" < 6050invalid@mynewsga
te.net> wrote in message
> news:200510031355266
050@mynewsgate.net...
>
>

[Venkat, MSFT}

2005-10-27, 7:54 am

Use the 'Generate Scripts Wizard'.
In Object explorer right click on the database that contains your tables.
Choose context menu 'Tasks\Generate Scripts...'
This would launch the 'Generate Scripts Wizard'.
You could use this wizard to generate scripts for all or selected tables in
the database.

Thanks,
[Venkat]
--
This posting is provided "as is" without inferring rights or warranties.

"Montag" wrote:

> Hi everybody
>
> I was looking for a tool that exports the structure of the tables of my
> SQL Server database. I've found some, but noone that exports also the
> description of the fields in the tables.
>
> Anyone knows about a tool that does it?
>
> giovanni
>
>

Sponsored Links