Help Center/ GaussDB(DWS)/ SQL Syntax Reference/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ DROP SUBSCRIPTION
Updated on 2024-09-02 GMT+08:00
View PDF
Share

DROP SUBSCRIPTION

Function

DROP SUBSCRIPTION deletes a subscription.

Precautions

  • This statement is supported by version 8.2.0.100 or later clusters.
  • A subscription can be deleted by the system administrator only.

Syntax

1
 
DROP SUBSCRIPTION [ IF EXISTS ] name

Parameter Description

  • IF EXISTS

    If the specified subscription does not exist, no error is thrown. Instead, a notification is reported indicating that the subscription does not exist.

  • name

    Specifies the name of the subscription you want to delete.

    Value range: an existing subscription

Examples

Delete a subscription. 
DROP SUBSCRIPTION mysub;

Helpful Links

ALTER SUBSCRIPTION, CREATE SUBSCRIPTION

Parent topic: DDL Syntax