<div>
... that's SQL Server 2000, btw
</div>


<div>
Simply script the whole Schema in ONE .sql file, create a new DB and run the .sql in it.
</div>


Simply script the whole Schema in ONE .sql file, create a new DB and run the .sql in it.

<div>
Hi DireOrbAnt,<br />
<br />
I know this question has been open for a long time. &nbsp;Sorry for not replying sooner.<br />
<br />
How Do I script &quot;the whole Schema in one .sql&quot;? &nbsp; I know I can click on each individual object, script to clipboard and past into the same window. &nbsp;but this seems rather cumbersome. &nbsp;I'm hoping there is a way to script the whole schema, as you suggest with a single command...<br />
<br />
thanks
</div>


Hi DireOrbAnt,

I know this question has been open for a long time.  Sorry for not replying sooner.

How Do I script "the whole Schema in one .sql"?   I know I can click on each individual object, script to clipboard and past into the same window.  but this seems rather cumbersome.  I'm hoping there is a way to script the whole schema, as you suggest with a single command...

thanks

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Does anyone have a SQL stored procedure that reads an existing database schema (tables, views, procedures, and functions) and creates a query that, when run, would create a blank copy of that existing database?<br />
<br />
I know I can do this manually from query analyzer, by right clicking on each object and creating the SQL for it. &nbsp;But, I'm hoping for an automated version :-)<br />
<br />
Thanks in advance!
</div>
</div>


Hello,

Does anyone have a SQL stored procedure that reads an existing database schema (tables, views, procedures, and functions) and creates a query that, when run, would create a blank copy of that existing database?

I know I can do this manually from query analyzer, by right clicking on each object and creating the SQL for it.  But, I'm hoping for an automated version :-)

Thanks in advance!

SQL Server procedure to create Database from existing Database

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.