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
To Convert a Materialized Query Table to a Regular Table
- 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.
- Click Execute. For information on the scheduling option, see Scheduling.