DROP PUBLICATION

Grammar Description

DROP PUBLICATION Delete an existing publish.

Grammar Structure

DROP PUBLICATION pubname;

Syntax Explanation

• pubname: an existing publishing name.

Example

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)