The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.
© Copyright 2010
Sign in
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 :)
July 29. 2008 09:34
Pingback from alvinashcraft.com Dew Drop - July 29, 2008 | Alvin Ashcraft's Morning Dew
alvinashcraft.com
July 31. 2008 14:16
Pingback from rtraction.com rtraction » Blog Archive » Generate Change Script for MySQL Modifications
rtraction.com