SHOW SUBSCRIPTIONS

Description

Returns a list of all subscription library names and source account names.

Syntax

1. SHOW SUBSCRIPTIONS;

Examples

1. Create database sub1 from sys publication pub1;

3. mysql> create database sub1 from sys publication sys_pub_1;
4. Query OK, 1 row affected (0.02 sec)

6. mysql> show subscriptions;
7. +------+--------------+
8. | Name | From_Account |
9. +------+--------------+
10. | sub1 | sys          |
11. +------+--------------+
12. 1 row in set (0.01 sec)