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

fivyi3re 于 2023-10-15 发布在 SQL Server

关注(0)|答案(2)|浏览(146)

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

sql-server

来源：https://stackoverflow.com/questions/23384628/script-table-as-alter-to-is-greyed-out-sql-server

2条答案

按热度按时间

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.

赞(0）回复(0）举报 2023-10-15

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.

赞(0）回复(0）举报 2023-10-15

我来回答

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

2条答案

相关问题

热门标签

最新问答