How to Delete Publications and Articles (Transact-SQL)

How to Install SQL Server 2000

How To

How to Delete Publications and Articles (Transact-SQL)

To delete a snapshot or transactional publication

  1. Execute sp_dropsubscription to delete all snapshot subscriptions.

  2. Execute sp_droppublication to delete the publication and all of its articles.

  3. Execute sp_replicationdboption to disable replication of the current database.

Note  Do not call sp_replicationdboption to disable publication of the current database if you are deleting only one publication and you still want to publish from the database.

To delete an article for a snapshot or transactional publication

  • Execute sp_droparticle to delete an article from a publication.

To delete a merge publication

  1. Execute sp_dropmergesubscription to delete all merge subscriptions.

  2. Execute sp_mergesubscription_cleanup to remove merge configuration for all merge articles in the subscription database.

  3. Execute sp_dropmergepublication to delete the publication and all of its articles.

  4. Execute sp_replicationdboption to disable replication of the current database.

Note  Do not call sp_replicationdboption to disable publication of the current database if you are deleting only one publication and you want to publish from the database.

To delete a merge article

  • Execute sp_dropmergearticle to delete an article from a publication.