Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Create new blank database from existing DB

Author  Topic 

ArpitNarula
Starting Member

16 Posts

Posted - 2011-03-09 : 07:51:17
Hi,

I need to create a new blank database(with constrainst but without data) using an existing DB (with data). How to go about it.

Thanks in Advance

vaibhavktiwari83
Aged Yak Warrior

843 Posts

Posted - 2011-03-09 : 07:59:37
Generate the database script from SQL Server management Studio for old database.
create new database
execute that script on new database.

Vaibhav T

If I cant go back, I want to go fast...
Go to Top of Page
   

- Advertisement -