Deletes one or more trigger definitions the physical database. Example: RDO> DELETE TRIGGER CURRENT_SALARY_TRIGGER.
1 – Format
(B)0[m[4mDELETE[m [4mTRIGGER[m 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.