SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-128
Examples of DROP TABLE
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 not saved as part of DDL text. However, the DDL text
includes DELETE statements to remove the default security information from the
metadata tables TBL_PRIVILEGES and COL_PRIVILEGES and INSERT statements
to record the correct security information. When recreating a dropped table, use a
licensed copy of MXCI to execute these DELETE and INSERT statements after you
create the table, to restore the security to the same state as when the table was
dropped.
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-67.
Examples of DROP TABLE
•
This example drops a table:
DROP TABLE mycat.mysch.mytable RESTRICT;