Neoview SQL Reference Manual (R2.2)

DROP TABLE Statement
• “Syntax Description of DROP TABLE”
• “Considerations for DROP TABLE”
• “Example 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 196).
DROP [VOLATILE] TABLE table
Syntax Description of DROP TABLE
table
is the name of the table to delete.
Considerations for DROP TABLE
Authorization and Availability Requirements
To drop a table, you must own the schema that contains the table.
Example of DROP TABLE
• This example drops a table:
DROP TABLE mysch.mytable;
• This example drops a volatile table:
DROP VOLATILE TABLE vtable;
98 SQL Statements