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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-118
DROP CATALOG Statement
DROP CATALOG Statement
Considerations for DROP CATALOG
Examples of DROP CATALOG
The DROP CATALOG statement deletes an empty SQL/MX catalog. See Catalogs on
page 6-2.
DROP CATALOG is an SQL/MX extension.
Syntax Description of DROP CATALOG
catalog
is the name of the empty catalog. You must drop all schemas from the catalog
before you can use the DROP CATALOG statement. This statement automatically
removes the SQL/MX user metadata (UMD) tables, system metadata, and MXCS
metadata tables associated with the catalog.
Considerations for DROP CATALOG
Reserved Catalogs
Catalog names beginning with NONSTOP_SQLMX_ are reserved for system
metadata. You are not allowed to drop the system metadata catalog.
Authorization and Availability Requirements
Any user can drop any empty catalog visible on the local node All metadata tables for
the catalog must be accessible at the time DROP CATALOG executes. No user can
drop a nonempty catalog, even if the catalog contains only empty schemas.
Examples of DROP CATALOG
•
This example drops an empty catalog:
DROP CATALOG mycatalog;
DROP CATALOG catalog