Link to home
Start Free TrialLog in
Avatar of Alex A
Alex A

asked on

SQL Server: creating table scripts

I have to recreate empty database from existing one: tables, views, constrains, indexes, defaults etc. What are my choices?
Thanks.
ASKER CERTIFIED SOLUTION
Avatar of Pushpakumara Mahagamage
Pushpakumara Mahagamage
Flag of Sri Lanka image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Type of data = schema only
Hi,

How much data? That is, how much of a pain would it be to simply restore the database and delete the unwanted data?

And, if you do the above, how much 'setup data' is in the database that then needs to be found and copied across?

Regards
  David
Hi,

Right click Database

In the Tasks Tab

Click on Generate Scripts

User generated image
Click Next

User generated image
Click Next
User generated image
Click on Advance

and Choose the option as below,

User generated image