示例:
创建一张teacher表
通常,为了确保表中数据的完整性和正确性,要给表中列添加约束
添加主键约束:
alter table TEACHER
add constraint pk_teacher primary key (TNO);
添加唯一约束:
alter table TEACHER
add constraint uk_teacher_tname unique(TNAME);
添加检查约束:
alter table TEACHER
add constraint ck_teacher_gender check(gender in ('男','女'));--约束性别只能是‘男’或者‘女’;
添加外键约束:
alter table TEACHER
add constraint fk_teacher_tno_dept foreignkey (TNO) references dept(DEPTNO)
注意:oracle里外键引用的那一列必须是主键;
删除约束的语法:
alter table 表名 drop constraint 约束名