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_DATABASE — VMS CDD+_4.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:

FormatExamples

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

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