DROP

The DROP statement deletes an object. Any objects that are directly or indirectly dependent on that object are also dropped. For example, if you drop a table, all of the privileges, constraints, and triggers on the table are also dropped. Whenever an object is dropped, its description is deleted from the catalog. You can drop the following objects:

When dropping a schema, table, type, or view, you can CASCADE or RESTRICT options:

Schema:

Table or view:

Type:

Example:

Drop your table named MY_IN_TRAY. Do not allow the drop if any views or indexes are created over this table.

DROP TABLE CORPDATA.MY_IN_TRAY RESTRICT 

For more information, see DROP in the SQL Reference topic in the Information CenterLink to Information center.