Copy database structure??

[Round]

Hello all,
This may be a question for the IIS forum but i'll put it here anyway.

Is there a way to copy a whole DB including tables, structure, views, and stored procedures but not the data so that I am left with an empty db?

We are using IIS and I use SQL Server Enterprise Manager to view and query the db's from the back end, but I can't work out ow to copy a db.

Cheers


P.S Thanks to all for all help previously, it's all much appreciated. Merry Xmas.

Cheers

[argoSquirrel]

Yeah.

Right click your DB >> tasks >> Generate Scripts.

I would also set Use Database to True as it will allow you to easily make a database of another name.

[bibby]

I couldn't help you with views or procedures, but structure is easy.


CREATE TABLE copy
SELECT * FROM original WHERE 0;