Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is there a way to get the ALTER statement run by the management studio when altering a table in the design view?

share|improve this question
No, the SQL Server table has to be closed to alter it, and there is no way to do it this way. – Andrew Smith Oct 23 '12 at 16:26
up vote 1 down vote accepted

I found the generate change script button. It appears after making a change via the designer window.

enter image description here

This allowed me to run the changes on other hosts with a query rather than going through the GUI again.

share|improve this answer
Care to add more detail? (Where did you find it? What did it do? Maybe a screenshot? :-) – voretaq7 Oct 23 '12 at 17:12
Added a screenshot. Thought maybe this was common knowledge – sreimer Oct 23 '12 at 19:29
It might be, but only about half of us spend any significant amount of time in Windows - Knowing where it is/what the icon looks like saves us from having to dig through menus or mouse over every icon and wait for the tooltip when we need to use the feature :-) – voretaq7 Oct 23 '12 at 19:35

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.