Generate DDL Statements via DDLGEN Sql Server 2000 / 2005

[Rahul]

Hi,
Is there any Stored procedure or function in SQL server to generate
DDL Statements without using any tool.
Alternative of DDLGEN of Sybase.

Urgent...

Regards
Rahul

[Russell Fields]

Rahul,

I don't quite understand your comment "without using any tool". Isn't
DDLGEN a tool? Did you mean: "Without buying an additional tool?"

Both SQL Server 2000 Enterprise Manager and SQL Server 2005 Management
Studio have options to script out the DDL for a database. Right click on a
database and look at the options available: Tasks \ Generate Scripts (it may
have a slightly different name in 2000).

Also there is a CodePlex project that you might find useful.
http://www.codeplex.com/wikipage?ProjectName=sqlhost&title=Database%20Publishing%20Wizard

RLF

"Rahul" wrote:

> .
>

[NetNewbie]

If it is just for one table, you can right click on the object and select
Script table as \create to \new query window.

For multiple objects, you can right click on the database and select
tasks\generate scripts and follow the steps of the wizard.

HTH
Hima

"Rahul" wrote:

> .
>

[Rahul]

On Dec 11, 8:02 pm, NetNewbie <NetNew...@discussions.microsoft.com>
wrote:

Hi,
Thanks for reply and sorry for late response from my side.
Actually, I does not want to use any front end tool, any third party
tool, SSMS or Enterprise Manager.
My requirement is generate DDL scripts.
--via using any script or stored procedure.
--Facilitate to provide any database object name (Table / View /
Stored Procedure / Function / User / Login / Type / Database).
--Facilitate to generate script for all object with in a database.

As mentioned in my previous mail DDLGEN utility is popular to generate
DDL script in SYBASE.
But I want the same in SQL Server (Any Version) and only without using
any front end tool.

Any help will be appreciated.

Regards
Rahul Verma