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

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

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

Is there any advantage for creating a default instance vs. a named

Hello, DBA outthere.
I understand that SQL Server 2000 allows 1 default instance and up to 15
named instances per server. I believe the default instance needs to be
created first.
Is there any reason to have more than 1 instance per server? Does having
more than one instance affect the overall SQL server performance? SQL
2000 server also allows server alias if users to have different server
naming.
I usually create named instance for new installation instead of letting
the SQL setup create the default instance. I had some run-ins with using
named instance. Some not-so-well-prepared application setups looks into
the registry for default instance
(HKL\Software\Microsoft\MSSQLServer\MSSQLServer). If whatever they looks
for is not there, the application will fail. Developers need to take
into account that as SQL Server allows DBA to create either default or
named instance or both.
In any event, give share your thoughts on using default or named instance.
Thanks.
JJ.Hi
Having multiple instances will stretch your resources more. You may want to
create multiple instances if you have a packaged application that require
specific settings or maybe because of issues of security.
I don't think you have to create the default instance first although I have
never tried doing otherwise!
John
"John Joe" <yukondba@.hotmail-lessspam.com> wrote in message
news:%234L5alHiEHA.592@.TK2MSFTNGP11.phx.gbl...
> Hello, DBA outthere.
> I understand that SQL Server 2000 allows 1 default instance and up to 15
> named instances per server. I believe the default instance needs to be
> created first.
> Is there any reason to have more than 1 instance per server? Does having
> more than one instance affect the overall SQL server performance? SQL
> 2000 server also allows server alias if users to have different server
> naming.
> I usually create named instance for new installation instead of letting
> the SQL setup create the default instance. I had some run-ins with using
> named instance. Some not-so-well-prepared application setups looks into
> the registry for default instance
> (HKL\Software\Microsoft\MSSQLServer\MSSQLServer). If whatever they looks
> for is not there, the application will fail. Developers need to take
> into account that as SQL Server allows DBA to create either default or
> named instance or both.
> In any event, give share your thoughts on using default or named instance.
> Thanks.
> JJ.