Contents Index Enforcing referential integrity Losing referential integrity

ASA SQL User's Guide
  Ensuring Data Integrity
    Enforcing entity and referential integrity

Foreign keys enforce referential integrity


Like primary keys, you use the CREATE TABLE or ALTER TABLE statements to create foreign keys. Once you create a foreign key, the column or columns in the key can contain only values that are present as primary key values in the table associated with the foreign key.

For more information about creating foreign keys, see Managing primary keys.


Contents Index Enforcing referential integrity Losing referential integrity