Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

Format

More

Examples

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:

FormatMoreExamples

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.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026