Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

Format

More

Examples

path-name

file-spec

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

 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:

FormatMoreExamples

Format

 DELETE DATABASE ───┬───> 
P

A

T

H

N

A

M

E
───> path-name ──┬──> . └───> 
F

I

L

E

N

A

M

E
───> file-spec ──┘

Additional information available:

path-namefile-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.

More

 You must have the ADMINISTRATOR privilege to the database to use the
 DELETE DATABASE statement.

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