# **DROP PUBLICATION**

## **Grammar Description**

`DROP PUBLICATION` Delete an existing publish.

## **Grammar Structure**

```sql
DROP PUBLICATION pubname;
```

## Syntax Explanation

- pubname: an existing publishing name.

## **Example**

```text
create database t;
create publication pub3 database t account ac0,acc1;

mysql> show publications;
+------+--------------+
| Name | Database |
+------+--------------+
| pub3 | t |
+------+--------------+
1 row in set (0.00 sec)

mysql> drop publication pub3;
Query OK, 0 rows affected (0.01 sec)

mysql> show publications;
Empty set (0.00 sec)
```