SHOW DATABASES IN REPLICATION GROUP¶

Lists databases in a replication group.

See also:

SHOW SHARES IN REPLICATION GROUP

Syntax¶

SHOW DATABASES IN REPLICATION GROUP <name>
Copy

Parameters¶

name

Specifies the identifier for the replication group.

Usage notes¶

  • Executing this command requires a role with either the OWNERSHIP or MONITOR privilege on the replication group. The command returns results only for a role with the MONITOR privilege on a database.

  • To retrieve the list of replication (and failover) groups in your organization, use SHOW REPLICATION GROUPS.

Examples¶

List the databases in the replication group myrg:

SHOW DATABASES IN REPLICATION GROUP myrg;
Copy