Select Clause Formats Foreign Keys
SELECT
1,
PKTABLE_OWNER,
PKTABLE_NAME,
1,
1,
FKTABLE_OWNER,
FKTABLE_NAME,
FKCOLUMN_NAME,
KEY_SEQ,
UPDATE_RULE,
DELETE_RULE,
FK_NAME
FROM ...
WHERE ...
• PKTABLE_OWNER: name of the owner of the primary key table (reference table)
• PKTABLE_NAME: name of the primary key table
• FKTABLE_OWNER: name of the owner of the foreign key table
• FKTABLE_NAME: name of the foreign key table
• FKCOLUMN_NAME: name of the foreign key column
• KEY_SEQ: number of the column in the key sequence (starts at 1)
• UPDATE_RULE : R: Restrict, C: Cascade
• DELETE_RULE : R: Restrict, C: Cascade
• FK_NAME: name of the foreign key; “1” if this name is not supported by the DBMS.