SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-005
2-184
Examples of DROP SCHEMA
Disk Type Specific Information:
*AuditTrailBuffer/SQLMXBuffer (MB)..... 0
*AutoRevive............................ OFF
*AutoSelect............................ n/a
*AutoStart............................. ON
*CBPoolLen............................. 1000
*FSTCaching............................ OFF
*FullCheckpoints....................... ENABLED
*HaltOnError........................... 1
*LKIDLongPoolLen....................... 8
*LKTableSpaceLen....................... 15
*MaxLocksPerOCB........................ 5000
*MaxLocksPerTCB........................ 10000
*NonAuditedInsert...................... OFF
More text? ([Y],N) n
Examples of DROP SCHEMA
•
This example drops an empty schema:
DROP SCHEMA sales RESTRICT;
DROP SEQUENCE Statement
Considerations for DROP SEQUENCE
Examples of DROP SEQUENCE
The DROP SEQUENCE statement drops a sequence generator from the current
schema. The operation removes all the USAGE privileges granted for the sequence
generator.
Syntax Description of DROP SEQUENCE
sequence
specifies the ANSI name of the sequence generator.
Considerations for DROP SEQUENCE
Authorization Requirements
The schema owner, Super ID or the object owner can execute a DROP
SEQUENCE statement.
DROP SEQUENCE sequence