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
Language: English