---
title: "DROP PUBLICATION"
url: "https://docs.yugabyte.com/stable/api/ysql/the-sql-language/statements/ddl_drop_publication/"
---

# DROP PUBLICATION

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

## Synopsis

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

## Syntax

- [![Grammar Icon](/icons/file-lines.svg)Grammar](#grammar-1)
- [![Diagram Icon](/icons/diagram.svg)Diagram](#diagram-1)

```output.ebnf
drop_publication ::= DROP PUBLICATION [ IF EXISTS ] publication_name 
                     [ CASCADE | RESTRICT ]
```

#### drop\_publication

DROPPUBLICATIONIFEXISTS[publication\_name](/stable/api/ysql/syntax_resources/grammar_diagrams#publication-name)CASCADERESTRICT

## 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.

```sql
yugabyte=# DROP PUBLICATION mypublication;
```

## See also

- [CREATE PUBLICATION](/stable/api/ysql/the-sql-language/statements/ddl_create_publication "CREATE PUBLICATION")
- [ALTER PUBLICATION](/stable/api/ysql/the-sql-language/statements/ddl_alter_publication "ALTER PUBLICATION")