Script table as - ALTER TO is greyed out - SQL SERVER

This command is not available for tables (but is for the other objects). The alternative is either to use "Design" from the same menu, or to write down your own change scripts. I'd definitely recommend to avoid the designer.


ALTER TO does not work for tables. You can however use Design to enter the Table Designer. When you are done with the changes you can either apply them directly or use Generate Change Script to get the SQL that SSMS would use when applying the changes you have made in the designer.