Changing a materialized query table to a base table

You can use the ALTER TABLE statement to change a materialized query table into a base table.

Procedure

Begin general-use programming interface information.To change a materialized query table to a base table:

Issue an ALTER TABLE statement and specify the DROP MATERIALIZED QUERY option.
For example, 
ALTER TABLE TRANSCOUNT DROP MATERIALIZED QUERY;

What to do next

After you issue this statement, Db2 can no longer use the table for query optimization, and you cannot populate the table by using the REFRESH TABLE statement. End general-use programming interface information.