SQL/MP Reference Manual

HP NonStop SQL/MP Reference Manual—523352-013

D-63

DROP Statement

DROP is a DDL statement that deletes a catalog, collation, constraint, index,

SQL-program Guardian file, table, or view, and deletes comments associated with the

dropped object.

CATALOG [ catalog ]

specifies the name (or an equivalent DEFINE) of an empty catalog to delete. If you

omit the catalog name, SQL deletes the default catalog.

COLLATION collation

specifies the name (or an equivalent DEFINE) of a collation to delete.

CONSTRAINT constraint ON table

specifies the name of a constraint to delete, and the name (or an equivalent

DEFINE) of the table with which the constraint is associated.

INDEX index

specifies the name (or an equivalent DEFINE) of an index to delete. index cannot

be a catalog index.

PROGRAM file

specifies the name (or an equivalent DEFINE) of a Guardian file that contains an

SQL program.

TABLE table

specifies the name (or an equivalent DEFINE) of a table to delete. table cannot

be a catalog table.

VIEW view

specifies the name (or an equivalent DEFINE) of a view to delete.

Considerations—DROP



DROP requires authority to read and write to the catalog that describes the object,

and to read and write to the catalogs of related objects that require changes

DROP { CATALOG [ catalog ] }

{ COLLATION collation }

{ CONSTRAINT constraint ON table }

{ INDEX index }

{ PROGRAM file }

{ TABLE table }

{ VIEW view }