To monitor the materialization or dematerialization of a subscription, use:
check subscription – finds the status of a subscription at the primary or replicate database.
To drop a subscription from a replicate database, use:
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.
