RDB/VMS Relational Database Operator DELETE_TRIGGER — VMS RDB_4.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 ──┬──> . └────── , <───────┘
Additional information available:
trigger-name
The name of the trigger to be deleted.
More
To delete a trigger, you must have the Rdb/VMS 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, Rdb/VMS starts a read/write transaction implicitly. 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.