It can be confusing at first
SQL ALTER TABLE Statement | SQL Server Tutorial for Beginners
In SQL 2005, you may need to generate an ALTER TABLE script, for example when you add a new column to a database or change the field type.
To generate a script for a specific SQL function, such as CREATE, SELECT, UPDATE, etc., you would normally right-click the table in SQL Management Studio and choose Script Table As and then the function you want to create a script for.
However, the ALTER To option is disabled in the Script Table as a menu option! So if you want to generate a script, how do you do that? Well, you can't do it this way if you are altering a table.
