Dropping a Replicated Column

To drop a replicated column

Remaster the replicate and modify the replicate's SELECT statement to remove the column being dropped, as described in Remastering a Replicate.
If the master replicate has shadow replicates defined, remove the column being dropped from their definitions as well.
Wait for the shadow replicate created by the remastering process to be cleaned up automatically.
To check when the shadow replicate has been deleted, look in the server log file for a message similar to this:
```
CDR CDRRTBCleaner: Deleted obsolete replicate
Shadow_4_Repl1_GMT1090373046_GID10_PID28836
```
The second line shows the name of the shadow replicate. See cdr remaster for information about the format of shadow replicate names.

Alternatively, you can use either the cdr list replicate or onstat -g cat repls command to view the status of the shadow replicate. After the shadow replicate has been deleted, these commands will no longer show information about it.
Use the ALTER TABLE statement to drop the columns from the replicated table at all participating nodes.