Provide a Different Replicate Column Name

Learn how to specify a replicate column name that is different from the primary column name.

To replicate data for the source column zip into a destination column named rep_zip2, enter:

alter replication definition publishers_rep
alter columns with zip as rep_zip

Enter such a command when:

You alter the existing destination table to add column rep_zip.
You drop and re-create the destination table to contain the column rep_zip in place of the original column zip.