Drop Publications

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 the publication.

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:

See Replication Server Reference Manual > Replication Server Commands > drop publication .

Drop Associated Replication Definitions
To drop replication definitions associated with the publication, include the drop_repdef clause when you execute drop publication.

Parent topic: Use Publications to Replicate Data at the Command Line

Related concepts

Drop Subscriptions for Publications and Articles