SQL/MP Installation and Management Guide

Adding, Altering, Removing, and Renaming
Database Objects
HP NonStop SQL/MP Installation and Management Guide—523353-004
7-29
Dropping Catalogs
This table summarizes the objects you can remove from the database and the
statements and commands that perform the operations. All these operations are
discussed in the following paragraphs except for dropping damaged SQL objects,
described in Purging Damaged Objects With the CLEANUP Utility on page 11-29.
For information about programs, see Section 10, Managing Database Applications.
Dropping Catalogs
To drop a catalog, use the DROP CATALOG statement. The catalog must be empty of
all user-defined SQL objects but will still contain the catalog tables and catalog table
index definitions.
To drop a catalog, follow these steps:
1. Start an SQLCI session. Enter a LOG command to initiate a log file for the
statements and commands entered in this session. Keep the log for your records.
2. Query the catalog tables for objects described in this catalog. Use the DISPLAY
USE OF command on each object to determine the dependencies.
3. Drop all the objects from the catalog: each user-defined table, view, index,
constraint, collation, comment, partition, and program registered in the catalog.
4. Enter the DROP CATALOG statement.
Object Operation Statement or Command
Catalog (all tables) Delete DROP CATALOG
Table File and definition
Data
DROP TABLE
PURGE
PURGEDATA
View File label and
definition
DROP VIEW
PURGE
Index File and definition DROP INDEX
PURGE
Partition Drop ALTER TABLE DROP PARTITION
ALTER INDEX DROP PARTITION
Column Delete DROP TABLE
Constraint Definition DROP CONSTRAINT
Collation Drop object DROP COLLATION
PURGE
Comment Definition COMMENT
Damaged SQL
object
Drop CLEANUP