Altering a table via SQL Server Management Studio - get SQL

Question

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

No, the SQL Server table has to be closed to alter it, and there is no way to do it this way.

sreimer · Accepted Answer · 2012-10-23 19:28:48Z

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.

edited Oct 23 '12 at 19:28

answered Oct 23 '12 at 16:54

sreimer
1,342210

	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

1 Answer