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