Dropping materialized query or staging tables

You cannot alter a materialized query or staging table, but you can drop it. All indexes, primary keys, foreign keys, and check constraints referencing the table are dropped. All views and triggers that reference the table are made inoperative. All packages depending on any object dropped or marked inoperative are invalidated.

About this task

A materialized query table might be explicitly dropped with the DROP TABLE statement, or it might be dropped implicitly if any of the underlying tables are dropped.

A staging table might be explicitly dropped with the DROP TABLE statement, or it might be dropped implicitly when its associated materialized query table is dropped.

Procedure

To drop a materialized query or staging table using the command line, enter:

   DROP TABLE table_name

The following statement drops the materialized query table XT:

   DROP TABLE XT