--示例1 ALTER TABLE stuInfo ADD CONSTRAINT PK_stuNo PRIMAR... --示例1 ALTER TABLE stuInfo ADD CONSTRAINT PK_stuNo PRIMARY KEY (stuNo) --示例2 添加主键约束(Primary Key) -- 存在主键约束PK_stuNO,则删除 IF EXISTS(SELECT * FROM sysobjects WHERE name='PK_stuNo' and xtype='PK') Alter TABLE stuInfo Drop Constraint PK_stuNo Go -- 重新添加主键约束PK_stuNO ALTER TABLE stuInfo ADD CONSTRAINT PK_stuNo PRIMARY KEY (stuNo) Go --示例3 添加 唯一UQ约束(Unique Constraint) -- 存在唯一约束UQ_stuNO,则删除 IF EXISTS(SELECT * FROM sysobjects WHERE name='UQ_stuID' and xtype='UQ') Alter TABLE stuInfo Drop Constraint UQ_stuID Go -- 重新添加唯一约束UQ_stuID ALTER TABLE stuInfo ADD CONSTRAINT UQ_stuID UNIQUE (stuID) --示例4 添加默认DF约束(Default Constraint) -- 存在默认约束UQ_stuNO,则删除 IF EXISTS(SELECT * FROM sysobjects WHERE name='DF_stuAddress' and xtype='D') Alter TABLE stuInfo Drop Constraint DF_stuAddress Go -- 重新添加默认约束DF_stuAddress ALTER TABLE stuInfo ADD CONSTRAINT DF_stuAddress DEFAULT ('地址不详') FOR stuAddress --示例5 检查CK约束(Check Constraint) -- 存在检查约束UQ_stuNO,则删除 IF EXISTS(SELECT * FROM sysobjects WHERE name='CK_stuAge' and xtype='C') Alter TABLE stuInfo Drop Cons
sql server 修改 约束条件
最新推荐文章于 2024-09-10 11:34:55 发布