Adding a Replicated Column

About this task

You can alter a replicated table to add a new column to be replicated. The replicate must be a master replicate.

To add a new replicated column

Procedure

  1. Use the ALTER TABLE statement to add the column to the replicated table at all participating nodes.
  2. Remaster the replicate to include the newly added column in the replicate definition, as described in Remastering a Replicate.