Use drop article to remove an article from a publication.
Before you drop an article, you must drop subscriptions created against it at the replicate Replication Server. See “Dropping subscriptions for publications and articles”.
Execute drop article at the Replication Server that manages the source database. You must have create object permission.
The following example drops the titles_art article for the pubs2_pub publication.
drop article titles_art for pubs2_pub with primary at TOKYO_DS.pubs2
Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for complete syntax and usage guidelines.
To drop a replication definition associated with an article, include the drop_repdef clause when you execute drop article. Replication Server drops the replication definition if it is not referenced in other publications or subscriptions.
For example, to drop the pubs2_pub article and the replication definition it references, enter:
drop article titles_art for pubs2_pub with primary at TOKYO_DS.pubs2 drop_repdef
