This section provides information on viewing, altering, and dropping replication definitions. It also describes how Replication Server supports table changes resulting from the alter table command when the table:
Has subscriptions from a replicate site, or
Is replicated to the standby database using a replication definition with a send standby replication definition columns clause.
Adaptive Server Enterprise version 12.0 allows users
to alter existing tables— add non-nullable columns, drop
columns, and modify column datatypes.
See “alter table support for warm standby” on page 111 in the Replication Server Administration Guide Volume 2 for more information about alter table changes that affect warm standby tables with no subscriptions.
For descriptions of procedures that require altering or dropping replication data, see “Modifying replicated data”.
