Changing an existing MQT into a shadow table

To change an existing MQT into a shadow table, you can modify the properties of the MQT.

Procedure

To create a shadow table from an existing MQT:

  1. Make sure that the Properties view is open, then select the materialized query table in the Data Project Explorer view. The properties of the object open in the Properties view.
  2. On the General page of the Properties view, specify a table organization, then change the Maintained by property to Replication.
    Restriction: Shadow tables can be row-organized or column-organized. However, if you want to specify a primary key for the table, you must set the Table organization property to Column. After you specify the correct table organization, you can specify the primary key on the Columns page of the Properties view of the table.