MSSQL Schema Export Only

• myukas

  SSC Eights!

  Points: 860

  More actions

  November 28, 2017 at 2:37 pm

  #1969813

  i found a way to automate it thank you

• Ricky Valencia

  SSCommitted

  Points: 1907

  More actions

  December 5, 2017 at 9:15 pm

  #1970838

  Hi Myukas,

  Below is another way to export schema only of your objects via MSSQL 

  1. Right click on the database > Tasks > Generate Scripts... > Next

  

  2. Choose objects that you want to script out. Click Next.

  

  3. Click Advanced.

  

  4. Under "Types of data to script", choose Schema Only (default option).

  

  5. Click OK > Next > Next > Finish

  There you go. I hope this helps.

  Best Regards,