Adaptive Server Enterprise version 12.0 and later allows users to alter existing tables—add non-nullable columns, drop columns, and modify column datatypes.
This section describes how Replication Server supports table changes resulting from the alter table command when the table has no subscriptions.
To support table changes that result from alter
table when subscriptions exist for that table, you need
to alter the table’s replication definition. See “Modifying
replication definitions” on page 281 in the Replication
Server Administration Guide Volume 1 for instructions.
In previous releases, when a replication definition was defined for a table, Replication Server always used the column datatype defined in the warm standby replication definition. Beginning with Replication Server version 12.0, and depending on the situation, Replication Server may or may not use a table’s replication definition.
