1.添加外键约束
示例:
SQL> CREATE TABLE student(
sid NUMBER(10) PRIMARY KEY, --主键约束
sname VARCHAR2(8),
sex CHAR(2),
classid NUMBER(3))
SQL> CREATE TABLE class(
cid NUMBER(3)PRIMARY KEY, --主键约束
cname VARCHAR2(20),
tel VARCHAR2(20))
SQL> ALTER TABLE student
ADD CONSTRAINT stu_class FOREIGN KEY(classid)
REFERENCES class(cid);
示例:
SQL> CREATE TABLE student(
sid NUMBER(10) PRIMARY KEY, --主键约束
sname VARCHAR2(8),
sex CHAR(2),
classid NUMBER(3))
SQL> CREATE TABLE class(
cid NUMBER(3)PRIMARY KEY, --主键约束
cname VARCHAR2(20),
tel VARCHAR2(20))
SQL> ALTER TABLE student
ADD CONSTRAINT stu_class FOREIGN KEY(classid)
REFERENCES class(cid);