Neoview SQL Reference Manual (R2.4)

DROP TABLE Statement
• “Syntax Description of DROP TABLE”
• “Considerations for DROP TABLE”
• “Examples of DROP TABLE”
The DROP TABLE statement deletes a Neoview SQL table and its dependent objects such as
indexes and constraints. See “Database Object Names” (page 228).
DROP [VOLATILE] TABLE table [RESTRICT|CASCADE]
Syntax Description of DROP TABLE
table
is the name of the table to delete.
RESTRICT
If you specify RESTRICT and the table is referenced by another object, the specified table
cannot be dropped. The default is RESTRICT.
CASCADE
If you specify CASCADE, the table and all objects referencing the table (such as a view) are
dropped.
Considerations for DROP TABLE
Authorization and Availability Requirements
To drop a table, you must be the table owner or the schema owner.
Examples of DROP TABLE
• This example drops a table:
DROP TABLE mysch.mytable;
• This example drops a volatile table:
DROP VOLATILE TABLE vtable;
114 SQL Statements