Copying a Database

[jalbao]

i have an existing database that i would like my 'model' database to be exactly like (excluding the table data).

for example: MyDBase is the name of a database that contains the tables that i need for my app. Th table in MyDBase also contains data. I want to somehow make the sql server 'model' database have the exact structure as MyDBase but without the table data.

how do i go about doing this?

 

[oneshadow]

not sure if this helps.
if MyDBase is a SQL Server database, then you should be able to generate a SQL script which will write the structure of MYDBase (tables, views, sp etc..).

you can then run this script in the destination database to create all objects with the same structure.