SQLSERVER添加删除列、添加修改删除各种约束
精选
转载
--添加列
alter table emp_info add test int;
--删除列
alter table emp_info drop column tableid;
--重命名表名
exec sp_rename 'calss','class';
--重命名列明
exec sp_rename 'class.calssname','classname','COLUMN';
--改变列长度
alter table emp_info alter column address nchar(100)
---------------------------------------
–添加约束
–添加主键
alter table student student
add constraint PK_stuNo primary key (studentNO) studentNo --studentNo 列明
–添加非空
alter table student
add constraint LoginPwd check (LoginPwd is not null)
–默认约束
alter table student
add constraint DF_address default('地址不详') for address;
–检查约束
alter table Student
add constraint CK_borndate CHECK(BornDate>='1980-01-01')
–唯一约束
alter table student
add constraint UQ_identityCard Unique (identityCard)
–外键约束
alter table result
add constraint FK_stuNo foreign key(studentNo) –外键列名
references student(studentNo) –student 主表
–删除约束
alter table student
drop constraint CK_borndate