Can we create 2 Foreign Keys on same column referring to 2 different tables

Database

Can we create 2 Foreign Keys on same column referring to 2 different tables

Hi,
Can we create 2 Foreign Keys on same column referring to 2 different tables

CREATE SET TABLE TEST ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
DATABLOCKSIZE = 130560 BYTES, CHECKSUM = DEFAULT
(
Sale_Date DATE FORMAT 'YYYY-MM-DD' NOT NULL,
Item_Id INTEGER NOT NULL,
Store_Party_Id INTEGER NOT NULL,
SAP_CUSTOMER_ID INTEGER,
FOREIGN KEY(SAP_CUSTOMER_ID ) REFERENCES WITH NO CHECK OPTION DIM_CUSTOMER ( Customer_Party_Id ),
FOREIGN KEY(SAP_CUSTOMER_ID ) REFERENCES WITH NO CHECK OPTION DIM_CUSTOMER_SALES (Customer_Party_Id ))

UNIQUE PRIMARY INDEX TEST ( Sale_Date ,Item_Id ,Store_Party_Id );

Thanks alot

Nick

1 REPLY

Re: Can we create 2 Foreign Keys on same column referring to 2 different tables

I did not have any problem while creating the tables. So I guess it might be possible.