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-190
Examples of DROP TABLE
The DDL is saved so that you can later retrieve it if you need to re-create the dropped
table for any reason. If the table needs to be recovered with TMF or re-created for use
in an RDF backup database, full Guardian file names are preserved and can be used
to create identical file names.
Grant and revoke privileges are saved as part of the DDL text.
DDL text is saved only for user base tables that are explicitly dropped with a DROP
TABLE statement. DDL text is not saved for tables that are implicitly dropped as a
result of DROP SCHEMA CASCADE or DROP TRIGGER statements (that is, dropping
the trigger temporary tables).
For details on this control query default, see Table Management on page 10-81.
Examples of DROP TABLE
•
This example drops a table:
DROP TABLE mycat.mysch.mytable RESTRICT;