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

Adding, Altering, and Dropping SQL/MX Database

Objects

HP NonStop SQL/MX Installation and Management Guide—523723-004

9-27

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-35.

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.

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