I want to script a table as Alter to a New Query Editor Window. But this option is disabled. How can I do this?
Use the "Design" function in SQL Server Management Studio to generate the ALTER script for you:
Depending on how you have your SSMS options set, this may not be available initially if the changes require tables to be dropped and re-created. To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Select or clear the Prevent saving changes that require the table to be re-created check box.
1) Right-click on the table you want to alter and choose Design
2) Add your new columns, change the field types, set your fields to accept NULLS or not, etc.
Important: Don't save your changes now
3) Do a right-click on any column or in the white space and you’ll see the option Generate Change Script is now available.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With