Return to destroy.nr CVS log

Up to [CSRG BSD Unix] / 42BSD / ingres / doc / quel

Annotation of 42BSD/ingres/doc/quel/destroy.nr, revision 1.1.1.1

1.1       root        1: .th DESTROY QUEL 2/21/79
                      2: .sh NAME
                      3: destroy \- destroy existing relation(s)
                      4: .sh SYNOPSIS
                      5: .bd destroy 
                      6: relname { , relname }
                      7: .br
                      8: .bd destroy 
                      9: [
                     10: .bd permit
                     11: |
                     12: .bd integrity
                     13: ] relname
                     14: [
                     15: integer { , integer }
                     16: |
                     17: .bd all
                     18: ]
                     19: .sh DESCRIPTION
                     20: .it Destroy 
                     21: removes relations from the data base,
                     22: and removes constraints or permissions from a relation.
                     23: Only the relation owner
                     24: may destroy a relation or its permissions and integrity
                     25: constraints.
                     26: A relation may be emptied of tuples, but not destroyed, using the delete
                     27: statement or the modify statement.
                     28: .s3
                     29: If the relation being destroyed has secondary
                     30: indices on it, the secondary indices are also destroyed.
                     31: Destruction of just a secondary index does not affect the
                     32: primary relation it indexes.
                     33: .s3
                     34: To destroy individual permissions or constraints for a relation,
                     35: the 
                     36: .it integer 
                     37: arguments should be those printed by a 
                     38: .bd "help permit"
                     39: (for 
                     40: .bd destroy 
                     41: .bd permit\c
                     42: )
                     43: or a 
                     44: .bd "help integrity"
                     45: (for 
                     46: .bd destroy
                     47: .bd integrity\c
                     48: ) on the same relation.
                     49: To destroy all constraints or permissions, the 
                     50: .bd all
                     51: keyword may be used in place of individual integers.
                     52: To destroy constraints or permissions, either the
                     53: .it integer
                     54: arguments or the
                     55: .bd all 
                     56: keyword must be present.
                     57: .sh EXAMPLE
                     58: .nf
                     59: /\*(** Destroy the emp relation \*(**/
                     60:     destroy emp
                     61:     destroy emp, parts
                     62: .s1
                     63: /\*(** Destroy some permissions on parts, and all integrity
                     64:  \*(** constraints on employee
                     65:  \*(**/
                     66:    destroy permit parts 0, 4, 5
                     67:    destroy integrity employee
                     68: .fi
                     69: .sh "SEE ALSO"
                     70: create(quel), delete(quel), help(quel), index(quel), modify(quel)

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.