Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> ForeignKey constraint
Can't find the correct way to define a foreign key constraint which refers to 2 fields.
Table1: (PrimaryKey are 2 Fields)
Field1_1 constraint CFK_Field1 references TableX(FieldX) Field1_2 Field1_3
Table5:
Field5_1 Field5_2 Field5_3 constraint CFK_Field5_3 references TABLE1(Field1_1, Field1_2) );
Many thanks in advance
Beat
-- +++ Beat Christen actiris_at_loxinfo.co.th Phuket/Thailand +++Received on Mon Feb 12 2001 - 01:47:40 CST