[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

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.
0
quasar_ee
Asked:
quasar_ee
  • 2
1 Solution
 
Pushpakumara MahagamageVPCommented:
Type of data = schema only
0
 
David ToddSenior DBACommented:
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
0
 
Vikas GargBusiness Intelligence DeveloperCommented:
Hi,

Right click Database

In the Tasks Tab

Click on Generate Scripts

Generate Script
Click Next

2
Click Next
3
Click on Advance

and Choose the option as below,

4
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now