Use drop publication to remove a publication and all of its articles from the system tables.
Before you drop a publication, you must, at the replicate Replication Server, drop all subscriptions created against it. See “Dropping subscriptions for publications and articles”.
Execute drop publication at the Replication Server that manages the source database. You must have create object permission.
The following example drops the pubs2_pub publication and the articles it contains.
drop publication pubs2_pub with primary at TOKYO_DS.pubs2
Publication information is dropped immediately from the primary Replication Server; it is not dropped from the replicate Replication Server until:
You attempt to create a subscription against the dropped publication, or
You enter check publication at the replicate Replication Server.
Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for complete syntax and usage guidelines.
To drop replication definitions associated with the publication, include the drop_repdef clause when you execute drop publication. Replication Server drops all replication definitions associated with the publication that are not referenced by other publications or subscriptions.
For example, to drop all replication definitions associated with pubs2_pub, enter:
drop publication pubs2_pub with primary at TOKYO_DS.pubs2 drop_repdef
