drop article

Description

Drops an article and optionally drops its replication definition.

Syntax

drop article article_name
for pub_name
with primary at data_server.database
[drop_repdef]

Parameters

article_name: The name of the article to drop.

for pub_name: Specifies the name of the publication the article is for.

with primary at data_server.database: 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.

drop_repdef: An optional keyword that causes the replication definition the article is for to be dropped—if it is not used elsewhere.

Examples

Example 1

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

Example 2

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

Usage

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

If you drop an article from an existing publication, the publication is invalidated. You must drop all existing article subscriptions using drop subscription for article before the article can be dropped. To create new publication subscriptions you must:
- 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.

Permissions

drop article requires “create object” permission.