Delete Constraint

Defines Uniface behavior when an occurrence of the One Entity is deleted, and there are related occurrences of the many entity available in the component data structure. Valid values are Restricted (default), Cascading, or Nullify.

Value	Description
Restricted	An occurrence of the One Entity cannot be deleted if there are occurrences of the Many Entity with a matching foreign key.
Cascading	If an occurrence of the One Entity is deleted, all occurrences in the Many Entity that have a matching foreign keys are also deleted.
Nullify	If an occurrence of the One Entity is deleted, the foreign key value of occurrences in the Many Entity that have a matching foreign key is set to NULL.

Related Topics