Drops an article and optionally drops its replication definition.
drop article <article_name >for <pub_name >with primary at <data_server>.<database >[drop_repdef]
The name of the article to drop.
Specifies the name of the publication the article is for.
Specifies the location of the primary data. If the primary database is part of a warm standby application, <data_server.database> is the name of the logical data server and database.
An optional keyword that causes the replication definition the article is for to be dropped—if it is not used elsewhere.
Drops the article named <titles_art> for the publication <pubs2_pub> in the TOKYO_DS.<pubs2> database:
drop article titles_art for pubs2_pub with primary at TOKYO_DS.pubs2
Drops the article named <titles_art> for the publication <pubs2_pub> in the TOKYO_DS.<pubs2> database. This command also drops the replication definition the article is for, if it is not used elsewhere:
drop article titles_art for pubs2_pub with primary at TOKYO_DS.pubs2 drop_repdef
Use drop article to remove an article from a publication. Execute drop article at the Replication Server that manages the database where the primary data is stored.
You can drop an article if there are no subscriptions for the article. Drop subscriptions first, as necessary.
Optionally, you can also drop the replication definition for the article, if it is not part of any other article and has no subscriptions.
A dropped article is removed at the replicate site only when create/define subscription is executed there.
Dropping Articles from a Publication with a Subscription
Validate the publication when you have completed making changes to the publication, then
See create subscription and define subscription for more information on the two methods of refreshing publication subscriptions.
drop article requires “create object” permission.