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 119 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”.
See “Replication definition restrictions in mixed-version systems” for mixed-version information.
