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:
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.