RDB/VMS Relational Database Operator DELETE_DATABASE — VMS RDB_3.1A
Deletes one or more databases. When this statement executes, Rdb/VMS
deletes the database files associated with the database. If you use
the PATHNAME qualifier, Rdb/VMS deletes the data dictionary directory
that contains the database definitions.
You cannot delete a database when there are users attached to the
database, including yourself. That is, issue the DELETE DATABASE
statement before you invoke the database.
USE THE DELETE DATABASE STATEMENT WITH CARE. When you use this
statement, Rdb/VMS deletes the physical database file, which includes
all data and all definitions.
Example:
DELETE DATABASE PATHNAME 'PERSONNEL'.
Additional information available:
Format
DELETE DATABASE ───┬───>
P
A
T
H
N
A
M
E ───> path-name ──┬──> . └───>
F
I
L
E
N
A
M
E ───> file-spec ──┘ path-name The full or relative data dictionary path-name for the database directory in which the definitions reside for the database you want to delete. Put the name in quotation marks. file-spec The VMS file specification for the database file containing the database you want to delete. If you use this qualifier, Rdb/VMS does not delete the database definitions from the data dictionary.
Examples
Example 1
Delete a database root file, storage area files, and snapshot files:
DELETE DATABASE FILENAME 'DISK2:[ACCOUNTING]MF_PERSONNEL'.
Example 2
Delete a database and its data dictionary definitions:
RDO> DELETE DATABASE PATHNAME 'DISK1:[DICTIONARY]CORP.MIS.PERSONNEL'.
This statement deletes:
o The RDB file and the SNP file referred to in the data dictionary
definition for the database (specified in the DEFINE DATABASE
statement)
o The data dictionary entity DISK1:[DICTIONARY]CORP.MIS.PERSONNEL