Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

Format

Examples

constraint-name

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

 Deletes one or more constraint definitions.  When the DELETE
 CONSTRAINT statement executes, Rdb/VMS deletes the constraint
 definition from the physical database.  If you use the PATHNAME
 qualifier when you invoke the database, DELETE CONSTRAINT also
 deletes the constraint definition from the data dictionary.

 You cannot delete a constraint definition unless you have invoked the
 database that includes the constraint.  You CANNOT delete a
 constraint definition when other users are attached to the database.

 Example:

      DELETE CONSTRAINT EMPLOYEE_ID_EXISTS.

Additional information available:

FormatExamples

Format

 DELETE CONSTRAINT ──┬──> constraint-name ──┬──> .
                     └─────<─── , ────<─────┘

Additional information available:

constraint-name

constraint-name

 The name of the constraint definition you want to delete.

Examples

 Example 1

 The following example deletes a single constraint definition:

 INVOKE DATABASE PATHNAME 'PERSONNEL'
 DELETE CONSTRAINT EMP_NUM_CON.

 This statement deletes EMP_NUM_CON from the physical database and the
 data dictionary.


 Example 2

 You can also delete more than one constraint definition at once:

 INVOKE DATABASE FILENAME 'PERSONNEL'
 DELETE CONSTRAINT SAL_CON,SS_NUM_CON.

 This statement deletes the two constraint definitions from the
 physical database.

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