ODBC Server Reference Manual

CORE SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
3-49
Dropping Partitioned Tables
The only way to clear the mapping table entries in this situation is to run the catalog
utility statement REFRESH.
For information about REFRESH, see Section 7, Managing Customized Catalogs.
Dropping Partitioned Tables
NonStop SQL/MP allows creation of partitioned tables. Each partition has an entry in
the mapping table. Dropping a table that is partitioned causes all the partitions to be
dropped, but the mapping entries will remain. To clear the entries, run the catalog utility
statement REFRESH.
CORE SQL Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is DROP TABLE, which, although it
does not include the CASCADE clause, functions the same as the CORE SQL
statement.
DROP VIEW
Use DROP VIEW to remove views from the database.
The DROP VIEW statement has the following syntax:
viewed-table-name
the view to drop. The viewed-table-name can be qualified with the owner
name.
CASCADE
specifies that all viewed tables based on viewed-table-name are also dropped.
CASCADE is the default specification.
RESTRICT
is not supported. The setting of the SQL_UNSUPPORTED flag in the ZNSPROF
mapping table determines whether the NonStop ODBC Server reports an error,
issues a warning message, or ignores the RESTRICT parameter.
Example
The following statement drops the MGRLIST view owned by PAYROLL_ADMIN:
drop view emplist payroll_admin.mgrlist cascade
The DROP VIEW statement also drops any views based on that view.
DROP VIEW viewed-table-name
[ CASCADE | RESTRICT ]