--添加列
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
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
转载于:https://blog.51cto.com/kingheihei/1191514