Drop Materialized Query Table

Go Up to Available object actions by DBMS

The Drop Materialized Query action lets you convert a materialized query table to a regular table.

Platform Availability

• DB2 LUW

To Convert a Materialized Query Table to a Regular Table

1. Initiate a Drop Materialized Query Table action against one or more materialized query tables. For more information see Initiating an object operation.

   The Confirm MQT Conversion to Regular dialog opens.

2. Click Execute. For information on the scheduling option, see Scheduling.