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)