Dynamic create table, create index based upon a given database

[A.M. de Jong]

Can I dynamically (from a stored procedure) generate
a create table script of all tables in a given database (with defaults etc)
a create view script of all views
a create function script of all functions
a create index script of all indexes.
(The result will be 4 scripts)

Arno de Jong,
The Netherlands.

[David Portas]

The following will create a script for each type of object:

EXEC XP_CMDSHELL '"C:\Program Files\Microsoft SQL
Server\MSSQL\Upgrade\SCPTXFR" /I /D DATABASE_NAME /S SERVER_NAME /F
C:\PATH_NAME'

--
David Portas
------------
Please reply only to the newsgroup
--

"A.M. de Jong" <ar****@wxs.nl> wrote in message
news:bp**********@reader10.wxs.nl...

Can I dynamically (from a stored procedure) generate
a create table script of all tables in a given database (with defaults etc) a create view script of all views
a create function script of all functions
a create index script of all indexes.
(The result will be 4 scripts)

Arno de Jong,
The Netherlands.