开发者

Is it possible to alter multiple columns in one statement in MS SQL?

I am trying to add default values to a group of columns, but I get a syntax error when I combine them all into one statement like this:

ALTER TABLE drawinglist 
ADD CONSTRAINT ISOKEYPLAN_DWGTITLEPREFIX_def DEFAULT 0 FOR ISOKEYPLAN_DWGTITLEPREFIX,
ADD CONSTRAINT PIPE_VENDOR_def DEFAULT 0 FOR PIPE_VENDOR;

Is the above syntax (or something similar) possible or do I have to separate them all out int开发者_运维技巧o their own statements?


The documentation for ALTER TABLE says you can. The SQL below should work:

ALTER TABLE drawinglist 
ADD 
    CONSTRAINT ISOKEYPLAN_DWGTITLEPREFIX_def DEFAULT 0 FOR ISOKEYPLAN_DWGTITLEPREFIX,
    CONSTRAINT PIPE_VENDOR_def DEFAULT 0 FOR PIPE_VENDOR;
GO

I tested on a dev database I have and that syntax worked in SQL Server 2008.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜