DROP SUBSCRIPTION ​

Function Description ​

DROP SUBSCRIPTION deletes a subscription from a database instance.

Precautions ​

• A subscription can be deleted only by the system administrator.
• If the subscription to be deleted is associated with a replication slot, DROP SUBSCRIPTION cannot be executed inside a transaction block.

Syntax ​

DROP SUBSCRIPTION [ IF EXISTS ] name [ CASCADE | RESTRICT ]

Parameter Description ​

• name

  Specifies the name of the subscription to be deleted.

• CASCADE|RESTRICT

  Currently, these keywords do not work because there is no dependency on subscriptions.

Example ​

For details, see Examples.

Helpful Links ​

ALTER SUBSCRIPTION, CREATE SUBSCRIPTION