SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-127

DROP SQL Statement

Considerations for DROP SQL

Examples of DROP SQL

The DROP SQL statement puts NonStop SQL/MX in an uninitialized state. It drops a

system catalog that has no user-created catalogs.

DROP SQL is an SQL/MX extension.

Considerations for DROP SQL

After you run the DROP SQL statement, you must run the InstallSqlmx script again to

re-enable the use of SQL on the system. See the SQL/MX Installation and

Management Guide for a description of this script.

Before executing DROP SQL, you must uninitialize NonStop MXCS. For information on

this procedure, see the SQL/MX Connectivity Service Manual.

Authorization and Availability Requirements

Only a SUPER user can execute this command. See Ownership on page 6-11. You

must drop all user catalogs before performing the DROP SQL statement.

Examples of DROP SQL

•

This example drops SQL on the system:

DROP SQL;

DROP SQL