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

fivyi3re  于 2023-10-15  发布在  SQL Server
关注(0)|答案(2)|浏览(145)

Script table as - ALTER TO is greyed out - SQL SERVER 2005 and sql server 2008. Is there any way to enable this>? or do we still write the alter command to alter any table?

It seems ALTER using right click on the object is only applicable to SPs and functions

ej83mcc0

ej83mcc01#

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.

k5ifujac

k5ifujac2#

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.

相关问题