Categories:

Account & Session DDL

SHOW DATABASES IN FAILOVER GROUP

Lists databases in a failover group.

See also:

SHOW SHARES IN FAILOVER GROUP

In this Topic:

Syntax

SHOW DATABASES IN FAILOVER GROUP <name>

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;
Back to top