Optional: Use this box to specify what action is to
take place on the dependent table when a row of the parent table is
deleted. Click on the down arrow and select one of the following
actions:
- No action
- Specifies that an error occurs for the DELETE operation on the parent
table and no rows are deleted. A delete rule of NO ACTION is enforced
after other referential constraints. NO ACTION is the default.
- Restrict
- Specifies that an error occurs for the DELETE operation on the parent
table and no rows are deleted. A delete rule of RESTRICT is enforced
before all other constraints.
- Cascade
- Specifies that the delete operation is propagated to the dependents of the
deleted row in the parent table.
- Set null
- Specifies that each nullable column of the foreign key of each dependent
of the deleted row is set to null. Do not specify this action unless
some column of the foreign key allows null values.
[ Top of Page |
Table of Contents |
Glossary |
Index ]
[ DB2 List of Books |
Search the DB2 Books ]