1  DELETE_TRIGGER
   Deletes one or more trigger definitions the physical database.

   Example:


   RDO> DELETE TRIGGER CURRENT_SALARY_TRIGGER.
 

2  Format

 (B)0DELETE TRIGGER  qwq trigger-name  qqwqq> .
                  mqqqqqq  , <qqqqqqqj

 

3  trigger-name
   The name of the trigger to be deleted.
 

2  More
   To delete a trigger, you must have the Oracle Rdb DELETE privilege
   to the relation for which the trigger is defined.

   You must execute this statement in a read/write transaction.
   If there is no active transaction and you issue this statement,
   Oracle Rdb starts a read/write transaction implicitly.

   Other users are allowed to be attached to the database when you
   issue the DELETE TRIGGER statement.
 

2  Examples
   Example 1

   Delete a single trigger definition:

   RDO> DELETE TRIGGER EMPLOYEE_ID_CASCADE_DELETE.

   This example shows the deletion of a trigger, EMPLOYEE_ID_
   CASCADE_DELETE.