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.