SHOW GROUP

Core command SHOW ENVIRONMENTS SH ENV SHENV SHOW ENVTS

Show all environments for a given Database Group

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 GROUP db01;
SHOW GROUP;

Notes

Lists the connections that share a Database Group with a given connection: SHOW GROUP [connectionId] [environmentName].

connectionId is optional and defaults to the current connection. Its Database Group is looked up, then every connection defined in the CDF with that same group 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). This is the SHOW GROUP example of docs/CONNECTION_MODEL.md §10.

A warning is shown instead if the connection doesn't exist or has no Database Group defined.

Phase 1 of the docs/CONNECTION_MODEL.md rework: this class replaces CommandShowEnvironments, whose primary keyword (SHOW ENVIRONMENTS) had already come to mean roughly what docs/CONNECTION_MODEL.md §10 specifies for SHOW GROUP - listing every connection sharing the current one's Instance (now Database Group), grouped by Environment. That keyword is kept, along with its other aliases (SH ENV/SHENV/ SHOW ENVTS), as backward-compatible aliases on this same command, per §11's explicit allowance ("Backward-compatible aliases may be retained internally if required"): `SHOW ENVIRONMENTS the keyword is not the same thing as SHOW ALL ENVIRONMENTS` (CommandShowAllEnvironments, the new, unrelated command listing the global Environment referential) - readers should not conflate the two on name alone.

Before that, this command had itself replaced SHOW INSTANCES (docs/TECHNICAL_CHANGE.md, 2026-09-05, "SHOW INSTANCES replaced by SHOW ENVIRONMENTS"): that earlier 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. SHOW INSTANCES was retired outright at the user's explicit request at the time, not kept as an alias.

Last modified in release 5.1.4.