Learn about other subscription commands.
check subscription – finds the status of a subscription at the primary or replicate database.
drop subscription – clears subscription information from system tables.
Optionally, you can use drop subscription with purge to remove the replicate data associated with a subscription. This process is called dematerialization.