SHOW INACTIVE CONNECTIONS

Displays list of all inactive database connections in the CDF file

Arguments

<databaseType> (optional) a database type. If provided, results are filtered accordingly

Examples

SHOW INACTIVE CONNECTIONS;
SHOW INACTIVE CONNECTIONS H2;

Notes

Lists every inactive (soft-deleted) database connection in the CDF: `SHOW INACTIVE CONNECTIONS`.

Prints one row per inactive connection (ID, type, name, user, database group, environment), sorted by ID, with a trailing count - the Linux/CLI equivalent of the config screen's "View inactive connections" toggle, using the exact same top/bottom dashed-separator table layout as CommandShowAllConnections. An inactive connection is invisible to every other command (CONNECT, SHOW ALL CONNECTIONS, SHOW CONNECTION, etc.) - this is the only way to discover an inactive connection's ID from the CLI, short of already knowing it, before using REACTIVATE CONNECTION or HARDDEL.

databaseType is optional; when given, only connections whose database type matches it exactly (case-insensitive) are listed - not a partial or wildcard match, exactly like `SHOW ALL CONNECTIONS`.

Last modified in release 5.1.6.