数据库添加与删除约束
一.添加
1.添加非空约束
ALTER TABLE student MODIFY COLUMN Sname VARCHAR (20) NOT NULL
2.添加默认约束
ALTER TABLE stufent MODIFY COLUMN Sage INT DEFAULT 18
3.添加主撻
(1)列级约束
ALTER TABLE student MODIFY COLUMN Sno INT PRIMARY KEY;
(2)表级约束
ALTER TABLE student ADD PRIMARY KEY (Sno)
4.添加唯一
(1)列级约束
ALTER TABLE student MODIFY COLUMN seat INT UNIQUE
(2)表级约束
ALTER TABLE student ADD UNIQUE (seat)
5.添加外键
ALTER TABLE sc ADD FOREIGN KEY (Sno) REFERENCES student(Sno)
二.删除
1.删除非空约束
ALTER TABLE student MODIFY COLUMN Sname VARCHAR(20) NULL
2.删除默认约束
ALTER TABLE student MODIFY COLUMN age INT
3.删除主键
ALTER TABLE student DROP FRIMARY KET
4.删除唯一
ALTER TABLE student DROP INDEX seat
5.删除外键
ALTER TABLE sc DROP FOREIGN REY Sno