从oracle中的两个差异的表主键建设复合外键

表格1：

tid(主键)//这里没有外键

表2：

sid(主键)//这里也没有外键

表3：

Tid
 Sid
 iid(primary key)
 foreign key(Tid,Sid) references table1(tid).table2(sid)

 In table3 i want to make a composite foreign key or composite foreign key constraint but failed . there are many questions related to this .But none of them seems helpful to me . How can i do that ? Is it valid ? Then what is the syntax of making composite foreign key from two different tables primary key

办理要领

您可以做的是为两个表建设两个差异的外键,如下所示：

CREATE TABLE table3(
    iid NUMBER,Tid NUMBER,Sid NUMBER,CONSTRAINT pk    PRIMARY KEY (iid) USING INDEX TABLESPACE idx,CONSTRAINT fk001 FOREIGN KEY (tid) REFERENCES table1(tid),CONSTRAINT fk002 FOREIGN KEY (sid) REFERENCES table2(sid)
);

（编辑：湖南网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!