Adding a Column to a Replication Definition

Learn to add a column to a replication definition.

To add a char column named zip (for zip code information) to the replication definition publishers:

Alter the replication definition to add the char column:

alter replication definition publishers_rep
add zip char(10)

If the column you added to the destination table has a different name from the source column such as rep_zip_char, enter:

alter replication definition publishers_rep
add zip as rep_zip char(10)

See Replication Server Reference Manual > Replication Server Commands > alter replication definition.