oracle 中表约束

 create table stu
(
  id number ptimary key,                                         主键约束
  name varchar2(20) not null,或 constraint stu_name_nn not null  非空约束
  grade number default 1,                                        默认约束
  email varchar2(50) unique, (插值时可以为null)         唯一约束
  class  number  references class(id),      外键约束class表的id字段
  constraint stu_name_email_uni unique(email,name),    组合唯一约束
  constraint stu_id_pk primary key(id),                也可以这样设置主键
  constraint stu_class_fk foreign key (class) references class(id) 也可以这样设置外键
)

 

删除约束：alter table stu drop constraint stu_class_fk(约束名)

添加外键约束：alter table stu add constraint stu_class_fk foreign key (class) references class(id)