Is there any tool for printing all table structure of a database

Dear all,
I am wondering if there is any tool which allows us to print out the table
structure of all tables in a database. Anyone knows?
Thanks a lot.
Hi,
Query the below system view.
INFORMATION_SCHEMA.COLUMNS
Thanks
Hari
SQL Server MVP
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
|||Right-Click your database, select All Tasks and then select Generate SQL
Scripts
"Ivan" <Ivan@.discussions.microsoft.com> wrote in message
news:616631D2-FB64-40E1-B61C-4BC5F495123B@.microsoft.com...
> Dear all,
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
|||On Fri, 26 Aug 2005 19:56:01 -0700, "Ivan"
<Ivan@.discussions.microsoft.com> wrote:
>I am wondering if there is any tool which allows us to print out the table
>structure of all tables in a database. Anyone knows?
>Thanks a lot.
Besides the previous two answers, also look at the diagram feature in
Enterprise Manager!
J.
|||
> I am wondering if there is any tool which allows us to print out the table
> structure of all tables in a database. Anyone knows?
> Thanks a lot.
If "print" really means "paper", check out the Schema Printing features
in our tool called Database Workbench - www.upscene.com
With regards,
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com