DROP PUBLICATION
Synopsis
Use the DROP PUBLICATION statement to remove a publication from a database.
Syntax
Grammar
Diagramdrop_publication ::= DROP PUBLICATION [ IF EXISTS ] publication_name
[ CASCADE | RESTRICT ]
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;