Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

Format

Examples

RDB/VMS Relational Database Operator DELETE_RELATION — VMS CDD+_4.1A

 Deletes one or more relation definitions.  When the DELETE RELATION
 statement executes, Rdb/VMS deletes the relation definition from the
 physical database.  If you use the PATHNAME qualifier when you invoke
 the database, DELETE RELATION also deletes the relation definition
 from the data dictionary.  You CANNOT delete a relation definition
 when there are active users.

 Example:

      DELETE RELATION COLLEGES.

Additional information available:

FormatExamples

Format

 DELETE RELATION ───┬────> relation-name ────┬─────> .
                    └─────<───── , <─────────┘

 relation-name   The name of the relation definition you want to
                 delete.

Examples


 Example 1

 Delete a single relation definition:

 RDO> INVOKE DATABASE PATHNAME "PERSONNEL"
 RDO> DELETE RELATION COLLEGES.
 RDO> COMMIT

 This statement deletes the definition for COLLEGES from the database
 file for PERSONNEL and from the data dictionary.


 Example 2

 Delete more than one relation definition:

 RDO> INVOKE DATABASE PATHNAME "PERSONNEL"
 RDO> DELETE RELATION DEGREES, COLLEGES.
 RDO> COMMIT

 This statement deletes both DEGREES and COLLEGES from the database
 file for PERSONNEL and from the data dictionary.

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