假设已知一个表是:
dept
(
ID number primary key,
name varchar2(10) unique
)我想创建一个表emp dept.ID 是emp.depID的外键
于是我这样写create table emp
(
depID number constraint fk_depID FOREIGN KEY REFERENCES to dept(ID)
)这样貌似不行,那么是怎么个写法呢,感谢!
dept
(
ID number primary key,
name varchar2(10) unique
)我想创建一个表emp dept.ID 是emp.depID的外键
于是我这样写create table emp
(
depID number constraint fk_depID FOREIGN KEY REFERENCES to dept(ID)
)这样貌似不行,那么是怎么个写法呢,感谢!
create table emp
(
depID number,
constraint fk_depID FOREIGN KEY(deptID) REFERENCES dept(ID)
)
--或者你这样写
create table emp(
depID number
);alter table emp add constraint fk_depID FOREIGN KEY(depID) REFERENCES dept(ID);
(
depID number,
constraint fk_depID FOREIGN KEY(deptID) REFERENCES dept(ID)
)