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 *

4 + 4 =


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">