MaxDB Maestro online Help
| Prev | Return to chapter overview | Next |
Setting reference options
Set rule ON DELETE from the respective drop-down list.
| • | RESTRICT Produce an error indicating that the deletion or update would create a foreign key constraint violation. |
| • | CASCADE Delete any rows referencing the deleted row, or update the value of the referencing column to the new value of the referenced column, respectively. |
| • | SET NULL Set the referencing column(s) to null. |
| • | SET DEFAULT Set the referencing column(s) to their default values. |
| Prev | Return to chapter overview | Next |






