DESTROY(QUEL) 2/21/79 DESTROY(QUEL) NAME destroy - destroy existing relation(s) SYNOPSIS destroy relname { , relname } destroy [ permit | integrity ] relname [ integer { , integer } | all ] destroy delim groupname DESCRIPTION Destroy removes relations from the data base, removes constraints or permissions from a relation, and removes user-defined delimitors. Only the relation owner may destroy a relation or its permissions and integrity constraints. A relation may be emptied of tuples, but not destroyed, using the delete statement or the modify statement. If the relation being destroyed has secondary indices on it, the secondary indices are also destroyed. Destruction of just a secondary index does not affect the primary relation it indexes. To destroy individual permissions or constraints for a relation, the integer arguments should be those printed by a help permit (for destroy permit) or a help integrity (for destroy integrity) on the same relation. To destroy all constraints or permissions, the all keyword may be used in place of individual integers. To destroy constraints or permissions, either the integer arguments or the all keyword must be present. To destroy a delimitor group, the groupname must be specified. This destroys the delimitors permanently, as opposed to unusing the group. EXAMPLE /* Destroy the emp relation */ destroy emp destroy emp, parts /* Destroy some permissions on parts, and all integrity * constraints on employee */ destroy permit parts 0, 4, 5 destroy integrity employee * Destroy the "paper" delimitor group */ destroy delim paper - 1 - DESTROY(QUEL) 2/21/79 DESTROY(QUEL) SEE ALSO create(quel), delete(quel), delim(quel), help(quel), index(quel), modify(quel) - 2 -