数据库手动设置约束

  现在是忙着作业，忙着博客，忙着考试，晕晕晕。。。。   手动设置约束，嘿嘿 瞧一瞧看一看楼！

--手动添加[主键约束]
alter table Employees add constraint PK_Employees_EmpId  primary key(EmpId)

--手动为EmpName增加非空约束
alter table Employees alter column EmpName varchar(50) not null

--手动为EmpName增加唯一约束
alter table Employees add constraint UQ_Employees_EmpName unique(EmpName)

--删除唯一建约束
alter table Employees drop constraint UQ_Employees_EmpName

--为性别增加默认约束,使默认值为'男'
alter table Employees add constraint DF_Employees_EmpGender default('男') for EmpGender

--位年龄增加检测约束 0-120含0和120
alter table Employees add constraint CK_Employees_EmpAge check(EmpAge>=0 and EmpAge<=120)

--为性别增加检测约束  非男即女
alter table Employees add constraint CK_Employees_EmpGender check(EmpGender='男' or EmpGender='女')

--为员工增加外键约束 现设DepId为主键
alter table Department add constraint PK_Department_DepId primary key(DepId)

alter table Employees add constraint FK_Employees_EmpDepId foreign key(EmpDepId) references Department(DepId)on delete cascade

--一条语句删除多个约束
alter table Employees drop constraint FK_Employees_EmpDepId,CK_Employees_EmpAge,UQ_Employees_EmpName

--一条语句增加多个约束
alter table Employees add constraint UQ_Employees_EmpName unique(EmpName),constraint CKSSS check(EmpAge>=0 and EmpAge<=120)