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:
Format
DELETE CONSTRAINT ──┬──> constraint-name ──┬──> . └─────<─── , ────<─────┘
Additional information available:
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.