Dematerialization Without Purging Rows

Dropping a subscription using the without purge option leaves the rows replicated by the subscription in the replicate table.

Subscriptions to function replication definitions are dropped automatically using the without purge option. You do not need to specify this option. You must, however, specify this option if you want to keep the rows in the replicate table. If you want to manually delete rows, you must use the with suspension option as well.