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-185
Examples of DROP SEQUENCE
Restrictions
The ANSI CASCADE option is not supported for sequence generators.
Recovery
Starting with SQL/MX Release 3.2.1, the SAVE_DROPPED_TABLE_DDL CQD
supports sequence generators. If you set this CQD to ON before executing a DROP
SEQUENCE statement, the DDL of the sequence generator is stored in an OSS file.
The DDL text is saved only for sequence generators that are explicitly dropped using a
DROP SEQUENCE statement and not for sequence generators implicitly dropped
using a DROP SCHEMA ... CASCADE operation.
Examples of DROP SEQUENCE
This example drops a sequence generator:
DROP SEQUENCE myseq;