SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—540440-003

2-124

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. See the SQL/MX

Connectivity Service Manual for details on this procedure.

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