DROP PUBLICATION

This page documents the preview (v2.21) version. Preview includes features under active development and is for development and testing only. For production, use the stable (v2024.1) version.

Synopsis

Use the DROP PUBLICATION statement to remove a publication from a database.

Syntax

drop_publication ::= DROP PUBLICATION [ IF EXISTS ] publication_name 
                     [ CASCADE | RESTRICT ]

drop_publication

DROPPUBLICATIONIFEXISTSpublication_nameCASCADERESTRICT

Semantics

Drop a publication named publication_name. If publication_name doesn't exist in the specified database, an error will be raised unless the IF EXISTS clause is used.

RESTRICT / CASCADE

These key words do not have any effect, since there are no dependencies on publications.

Permissions

A publication can only be dropped by its owner or a superuser.

Examples

Basic example.

yugabyte=# DROP PUBLICATION mypublication;

See also