RDB/VMS Relational Database Operator DELETE_TRIGGER — VMS RDB_3.1A
Deletes one or more trigger definitions the physical database.
Example:
RDO> DELETE TRIGGER CURRENT_SALARY_TRIGGER.
Additional information available:
Format
DELETE TRIGGER ─┬─ trigger-name ──┬──> . └────── , <───────┘ trigger-name The name of the trigger to be deleted.
More
You must execute this statement in a read/write transaction. If there is no active transaction and you issue this statement, Rdb/VMS starts a read/write transaction implicitly. To delete a trigger, you must have DELETE access to the relation for which the trigger is defined. Other users are allowed to be attached to the database when you issue the DELETE TRIGGER statement.
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.