Help Center/ GaussDB/ Developer Guide(Centralized_2.x)/ SQL Reference/ SQL Syntax/ DROP PUBLICATION
Updated on 2023-10-23 GMT+08:00
View PDF
Share

DROP PUBLICATION

Function

DROP PUBLICATION deletes an existing publication from a database.

Precautions

A publication can be deleted only by its owner or the system administrator.

Syntax

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

Parameter Description

  • IF EXISTS

    Does not throw an error if a publication does not exist, but instead reports a notice.

  • name

    Specifies the name of an existing publication.

  • CASCADE|RESTRICT

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

Examples

For details, see Examples.

Helpful Links

ALTER PUBLICATION and CREATE PUBLICATION

Parent topic: SQL Syntax