SHOW DATABASES IN FAILOVER GROUP¶

Lists databases in a failover group.

See also:

SHOW SHARES IN FAILOVER GROUP

Syntax¶

SHOW DATABASES IN FAILOVER GROUP <name>
Copy

Parameters¶

name

Specifies the identifier for the failover group.

Usage notes¶

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

  • To retrieve the list of failover groups in your organization, use SHOW FAILOVER GROUPS.

Examples¶

List the databases in the failover group myfg:

SHOW DATABASES IN FAILOVER GROUP myfg;
Copy