SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

ManualsBrandsHP ManualsServerHP Integrity NonStop H-Series

SQL/MX Statements

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001

2-161

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;