Before you can delete a replicate article from a subscription, you must first suspend the subscription. After the replicate article is deleted, you can resume the subscription.
See “Suspending and resuming subscriptions” for more information.
If the replicate table was created by ASE Replicator when the replicate article was created, ASE Replicator deletes the replicate table in the replicate database when you delete the replicate article.
To delete a replicate article, use sp_dropreplicateart and specify the subscription name, and the name of the replicate article:
sp_dropreplicateart sub_name, rep_art
where sub_name is the name of the subscription, and rep_art is the name of the replicate article.
The sp_dropreplicateart procedure gives you the option of deleting all replicate articles in a subscription.
To delete all replicate articles in a subscription, use sp_dropreplicateart and specify only the subscription name:
where sub_name is the name of the subscription you want to delete all replicate articles from.