DROP SUBSCRIPTION

Go Up to Statement and Function Reference (Language Reference Guide)

To eliminate interest in observing a set of change views, a subscription must be dropped.

DROP SUBSCRIPTION <subscription_name> [RESTRICT | CASCADE ];

Important:
If RESTRICT is specified then a check of existing subscribers is performed. If there are subscribers then an error is returned without dropping the subscription. If CASCADE is specified then all subscribers of this subscription are also dropped. If neither RESTRICT nor CASCADE is specified then RESTRICT is assumed.

Argument	Description
<RESTRICT>	Checks existing subscribers.
CASCADE	All subscribers of the subscription are dropped.

See Also

• SET SUBSCRIPTION
• CREATE SUBSCRIPTION
• Data Definition Guide

Advance To:

• DROP SHADOW