Show TOC

drop publicationLocate this document in the navigation structure

Drops a publication and all of its articles, and optionally drops the replication definitions for the articles.

Syntax
drop publication <pub_name>
with primary at <data_server>.<database
>[drop_repdef]
Parameters
pub_name

The name of the publication to drop.

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 definitions for the publication’s articles to be dropped—if it is not used elsewhere.

Examples
Example 1

Drops the publication named <pubs2_pub> for the primary database TOKYO_DS.<pubs2>:

drop publication pubs2_pub
 with primary at TOKYO_DS.pubs2
Example 2

Drops the publication named <pubs2_pub> for the primary database TOKYO_DS.<pubs2>. This command also drops all the replication definitions for the publication’s articles, for replication definitions that are not used elsewhere:

drop publication pubs2_pub
 with primary at TOKYO_DS.pubs2
 drop_repdef
Usage
  • Use drop publication to remove a publication. Execute drop publication at the Replication Server that manages the database where the primary data is stored.

  • You can drop a publication if there are no subscriptions for the publication. Drop subscriptions first, as necessary.

  • When you drop a publication, its articles are also dropped. Optionally, you can also drop all of the replication definitions for the publication’s articles, if they are not part of any other article and have no subscriptions.

  • A dropped publication is removed from a replicate site when define/create subscription or check publication is executed there for the publication.

Permissions

drop publication requires “create object” permission.