如果我有这样的声明:
ALTER TABLE RecipeBox.Recipe ADD CONSTRAINT AKRecipeBox_Recipe_Name
UNIQUE NONCLUSTERED (Name)
如何在此语句中添加其他约束?这有可能吗?
谢谢
使用sql SERVER 2008 Developer Edition
添加逗号,然后
添加新约束(不
添加关键字),如下所示:
ALTER TABLE RecipeBox.Recipe ADD CONSTRAINT AKRecipeBox_Recipe_Name
UNIQUE NONCLUSTERED (Name),CONSTRAINT your_constraint UNIQUE NONCLUSTERED (yourColumn) -- (or whatever type of constraint you're looking for)
原文链接:https://www.f2er.com/mssql/77414.html