SHOW CREATE PUBLICATION

Grammar Description

Returns the SQL statement at the time of PUBLICATION creation.

Grammar Structure

SHOW CREATE PUBLICATION pubname;

Example

create database t;
create publication pub3 database t account ac0,acc1;
mysql> alter publication pub3 account add accx;
Query OK, 0 rows affected (0.00 sec)

mysql> show create publication pub3;
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Publication | Create Publication |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| pub3 | CREATE PUBLICATION `pub3` DATABASE `t` ACCOUNT `acc0`, `acc1`, `accx` |
+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.01 sec)