SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—640322-001
2-130
Examples of DROP SCHEMA
*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;