RDOHELP72.HLB  —  DELETE_TRIGGER
    Deletes one or more trigger definitions the physical database.

    Example:

    RDO> DELETE TRIGGER CURRENT_SALARY_TRIGGER.

1  –  Format

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

1.1  –  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.

3  –  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.
Close Help