Quick Tip: Generate Change Script for SQL Modifications

This is probably another thing that many people know but it's new to me. In the Modify table window, you can generate a script to show the ALTER TABLE that Management Studio creates.

Make your change (add column / delete column / change a columns data type, etc.)

  Click the 'Generate Change Script' button (this option is not at all hidden but was something I didn't take the time to use because I never needed it before). 

View the dialog with the change script

Thanks to my friend Ross for pointing this out to me. He really needs to start blogging these tips :)

Tags: sql, tip, management studio
Categories: Development
Actions: E-mail | Kick it! | Permalink | Comments (3) | Comment RSS