SHOW INSTANCES
Show all instances for a given platform
Arguments
<platformName> (optional) the name of the platform, current platform if empty. <instanceName> (optional) the name of the instance, all instances if empty
Examples
SHOW CONNECTION db01;
SHOW CONNECTION;
Notes
Lists the connections that share a landscape with a given connection: SHOW INSTANCES [connectionId] [instanceName].
connectionId is optional and defaults to the current connection. Its landscape is looked up, then every connection defined in the CDF with that same landscape is listed (ID, user, name, type), grouped by instance, with a trailing count. instanceName is optional and, if given, restricts the list to connections whose instance matches it exactly (case-insensitive).
A warning is shown instead if the connection doesn't exist or has no landscape defined.
Last modified in release 4.9.8.
BroadSQL