Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

Format

More

Examples

trigger-name

RDB/VMS Relational Database Operator DELETE_TRIGGER — VMS RDB_4.0

 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  ──┬──> .
                  └──────  , <───────┘

Additional information available:

trigger-name

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.

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