SQL/MX Quick Start (G06.24+, H06.03+)

Creating Database Objects
HP NonStop SQL/MX Quick Start—523724-002
9-4
Dropping Objects
Dropping Objects
You might want to delete the objects you have created.
Example
To delete the view, at the MXCI prompt, enter:
DROP VIEW MYCAT.MYSCH.MYVIEW;
Example
To delete the table, at the MXCI prompt, enter:
DROP TABLE MYCAT.MYSCH.MYTABLE;
Example
To delete the schema, at the MXCI prompt, enter:
DROP SCHEMA MYCAT.MYSCH;
Example
To delete the catalog you have created, at the MXCI prompt, enter:
DROP CATALOG MYCAT;
Tip
•
To drop a catalog, you must first drop all schemas in that catalog.
•
To drop a schema, you must first drop all tables in that schema.
•
To make sure you are dropping the correct view or table, use its fully qualified
name, as shown in the previous examples.