NexusDB V3 Manual
Deleting Predicate
|
|
NexusDB Manual V3 > SQL Reference > Predicates
|
Testing if a trigger event is DELETE.
Syntax
<deleting predicate> ::= DELETING
Notes
§
|
The DELETING predicate can only be specified in the body of a trigger definition to check the trigger event.
|
§
|
The predicate evaluates to TRUE if the trigger was activated by an DELETE operation on the table, else to FALSE.
|
Examples
1)
|
The following example shows how the DELETING predicate is used in the WHEN clause of a triggered action:
|
WHEN ( DELETING )
triggered SQL statements
IF DELETING THEN ... END IF;
Conformance
NexusDB extensions
|
-
|
DELETING predicate
|
|
© Nexus Database Systems Pty Ltd.