To rename a replicated table:
In Adaptive Server, use sp_setreplicate to disable replication for the table. See sp_setreplicate in Chapter 5, “Adaptive Server Commands and System Procedures” in the Replication Server Reference Manual.
Use drop subscription to drop subscriptions to all of the table’s replication definitions. See “Using the drop subscription command”.
Use drop replication definition to drop all of the table’s replication definitions. See “Dropping replication definitions”.
Rename the destination table.
Follow the steps in the “Replication procedure”. Be sure to specify the table names correctly, as described under “Specifying the replication definition name and table names”.
