Generate Script of Database in SQL-Server

Script of Database in SQL-Server

 

  • Generate Script of Database in SQL-Server. 
  • Using Script you can get/restore the Table Column without Data. 
  • First Select the Database, which you want to generate the script. 
  • Right click on Database and select Tasks Tab and Select Generate¬† Script Option.
  • Database —> Tasks —-> Generate Scripts.
  • After doing this you will have a below screen, select script all object in the database option.
  • Below code is your script code for database backup without Data.

Leave a Reply

Your email address will not be published. Required fields are marked *

12 + eighteen =