Dropping articles

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.