BroadSQLSHOW ENVIRONMENTS
Show all environments for a given instance
Arguments
<platformName> (optional) the name of the platform, current platform if empty. <environmentName> (optional) the name of the environment, all environments if empty
Examples
SHOW ENVIRONMENTS db01;
SHOW ENVIRONMENTS;Notes
Lists the connections that share an instance with a given connection: SHOW ENVIRONMENTS [connectionId] [environmentName].
connectionId is optional and defaults to the current connection. Its instance is looked up, then every connection defined in the CDF with that same instance is listed (ID, user, name, type), grouped by environment, with a trailing count. environmentName is optional and, if given, restricts the list to connections whose environment matches it exactly (case-insensitive).
A warning is shown instead if the connection doesn't exist or has no instance defined.
Replaces SHOW INSTANCES (docs/TECHNICAL_CHANGE.md, 2026-09-05, "SHOW INSTANCES replaced by SHOW ENVIRONMENTS"): that command fixed the current connection's Environment and listed every connection sharing it across every Instance - the wrong axis once Instance/Environment held their correct, post-swap meaning (the user needed the reverse: fix the current connection's Instance, list every Environment within it). Retired outright at the user's explicit request, not kept as an alias.
Last modified in release 5.1.3.