Help Center/ Data Warehouse Service/ SQL Syntax Reference/ SQL Syntax Reference (9.1.1.x)/ DDL Syntax/ Publications and Subscriptions/ DROP SUBSCRIPTION
Updated on 2026-07-02 GMT+08:00
View PDF
Share

DROP SUBSCRIPTION

Function

DROP SUBSCRIPTION deletes a subscription.

This syntax has been deprecated in clusters of version 9.1.1.100 or later. An error "SUBSCRIPTION is not yet supported" will be reported when executed.

Precautions

A subscription can be deleted by the system administrator only.

Syntax

1
 
DROP SUBSCRIPTION [ IF EXISTS ] name;

Parameter Description

Table 1 DROP SUBSCRIPTION parameters

Parameter

Description

Value Range

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.

An existing subscription.

Examples

Delete a subscription. 
DROP SUBSCRIPTION mysub;

Helpful Links

ALTER SUBSCRIPTION, CREATE SUBSCRIPTION

Parent Topic: Publications and Subscriptions