DROP PUBLICATION

DROP PUBLICATION deletes a publication.

This statement is supported by version 8.2.0.100 or later clusters.
This statement can be used by the publication owner and system administrators only.

 DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
 

**Table 1** DROP PUBLICATION parameters
Parameter	Description	Value Range
IF EXISTS	If the specified publication does not exist, no error is thrown. Instead, a notification is reported indicating that the publication does not exist.	-
name	Specifies the name of the publication you want to delete.	An existing publication.
CASCADE \| RESTRICT	Currently, these keywords do not work because there is no dependency on publications.	-

Delete a publication.

DROP PUBLICATION mypublication;

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.