Foreign Key Creation

Use the CREATE TABLE statement or ALTER TABLE statement to create foreign keys, as you do primary keys.

Note: You cannot create foreign key constraints on local temporary tables. Global temporary tables must be created with ON COMMIT PRESERVE ROWS.
Parent topic: Referential Integrity
Related concepts
Entity and Referential Integrity
Star Joins
Related tasks
Creating Foreign Keys