Before you drop a replication definition, first drop all subscriptions and articles that reference that replication definition. See Chapter 11, “Managing Subscriptions” for details on dropping subscriptions. See “Dropping articles” for details on dropping articles.
To access a list of existing subscriptions for a specified replication definition, use rs_helpsub. See rs_helpsub in Chapter 6, “Adaptive Server Stored Procedures” in the Replication Server Reference Manual for more information.
To access a list of existing subscriptions for all replication definitions, use rs_helprep. See rs_helprep in Chapter 6, “Adaptive Server Stored Procedures” in the Replication Server Reference Manual for more information.
Enter drop replication definition at the primary Replication Server. For example, to drop the publishers_rep replication definition, enter a command like this:
drop replication definition publishers_rep
Refer to Chapter 3, “Replication Server Commands” in the Replication Server Reference Manual for more information about drop replication definition command.
