HomeMogDBMogDB StackUqbar
v3.1

Documentation:v3.1

Supported Versions:

Other Versions:

DROP SUBSCRIPTION

Function

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

DropSubscription ::= 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.

Examples

For details, see Examples in CREATE SUBSCRIPTION.

ALTER SUBSCRIPTION, CREATE SUBSCRIPTION

Copyright © 2011-2024 www.enmotech.com All rights reserved.