Show TOC

drop articleLocate this document in the navigation structure

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.

Related Information