solidDB maintains referential integrity by taking action when referential constraints are violated. Referential constraints are violated, for example, in the following cases:
▪ A row that contains an invalid foreign key value is inserted in the referencing table.
▪ A foreign key in the referencing table is updated to an invalid value.
▪ A row with a referenced primary key is deleted from the referenced table.
▪ A referenced primary key is updated in the referenced table.
The referential action is defined as part of the table constraint definition in a CREATE TABLE or ALTER TABLE statement, see CREATE TABLE:
Constraints can be managed dynamically with the ALTER TABLE clause, see ALTER TABLE.