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.