Changing the definition of a materialized query table

After you create a materialized query table, you can change the definition in one of two ways.

To change the definition of an existing materialized query table, use one of the following approaches:

• Optional: Drop and re-create the materialized query table with a different definition.
• Optional: Use ALTER TABLE statement to change the materialized query table into a base table. Then, change it back to a materialized query table with a different but equivalent definition (that is, with a different but equivalent SELECT for the query).