go
Alter Table Student ADD Demo varchar(50);--添加列(属性)
go
Alter Table Student Alter Column Demo int;--修改数据类型
go
Alter Table Student ADD Constraint [DF_Demo] Default(0) For Demo;--添加默认值约束
Alter Table Student ADD Constraint [CK_Demo] Check(Demo>=0 And Demo<=100);--添加限制约束
Alter Table Student ADD Constraint [IX_Demo] Unique(Demo);--添加唯一约束
go
Alter Table Student ADD Constraint [PK_Son] Primary Key(Sno);--添加主键约束
Alter Table SC ADD Constraint [FK_Son] Foreign Key(Sno) References Student(Sno);--添加外键约束
go
Alter Table Student NOCheck Constraint [CK_Demo];--关闭约束
Alter Table Student Check Constraint [CK_Demo];--重启约束
go
Alter Table Student Drop Constraint [CK_Demo];--删除约束
Alter Table Student Drop Column [Demo];--删除列(属性)
go
SQL 表的约束
于 2023-11-29 09:28:29 首次发布