SQL/MX 2.x Installation and Management Guide (H06.10+, J06.03+)

Adding, Altering, and Dropping SQL/MX Database
Objects
HP NonStop SQL/MX Installation and Management Guide—544536-007
9-26
Dropping Objects From an SQL/MX Database
3. Enter the GRANT or REVOKE statements.
For more information and examples of altering views, see the SQL/MX Reference
Manual.
Dropping Objects From an SQL/MX Database
Table 9-5 summarizes the objects that you can remove from the database and the
statements, commands, and utilities to use. All these operations are discussed in this
subsection except for dropping damaged SQL objects, which is described in Using
GOAWAY to Delete Damaged Objects on page 12-36.
For detailed information about these statement, utilities, or the objects they affect, see
the SQL/MX Reference Manual. For information about application programs, see
Section 11, Managing Database Applications.
Authorization Requirements for Dropping Database Objects
Table 9-6 describes the authorization requirement for each drop operation.
Table 9-5. Dropping Objects From an SQL/MX Database
Object Operation Statement, Command or Utility
Catalog Drop DROP CATALOG statement
Constraint Drop ALTER TABLE DROP CONSTRAINT
statement
Index Drop data, file and
definition
DROP INDEX statement
Partition Drop data, file and
definition
MODIFY utility
Drop data only PURGEDATA utility
Schema Drop schema DROP SCHEMA statement
SQL/MP alias Drop the map DROP SQLMP ALIAS statement
Stored procedures
in Java (SPJ)
Drop procedure DROP PROCEDURE statement
Table Drop data, files and
definition
DROP TABLE statement
Drop data only PURGEDATA utility
Trigger Drop trigger DROP TRIGGER statement
View Drop view DROP VIEW statement