Deleting Predicate

Wed, 03/04/2009 - 20:02 |  hdanzl

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

2) The following example shows how the DELETING predicate is used in a triggered SQL statement:

       IF DELETING THEN ... END IF;


Conformance

NexusDB extensions

-

DELETING predicate
‹ Updating PredicateupStored Procedures and Functions ›
Print this chapter |  Login or register to post comments |  Send to friend |  PDF version |  metadata Tags:
Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | Predicates

Powered by Drupal and Drupal Theme created with Artisteer.