When there is a send standby replication definition columns clause in the replication definition, the standby will continue to use the replicate table name and column names as well as the datatype defined in the table’s corresponding replication definition.
If you want the replication definition datatype to be used in the standby, always create a replication definition with a send standby replication definition columns clause.
Please note that:
To add or alter columns in the primary database, follow the “Migration procedure” on page 284 in the Replication Server Administration Guide Volume 1.
To drop columns in the primary database, you do not need to alter the replication definition of the table as long as you do not drop all primary key columns.
To drop all primary key columns, alter the replication definition to add new primary key columns before you alter the primary table. You can drop the old primary keys when the old data rows have been removed from the replication system.
