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
Showing posts with label printing. Show all posts
Showing posts with label printing. Show all posts
Wednesday, March 7, 2012
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
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
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
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
Subscribe to:
Posts (Atom)