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     ! 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.