Show Connections

Syntax

SHOW CONNECTIONS

Description

If there are no connections, the command returns "No connections available".

Otherwise, the command displays a list of connection names and the URLs used to connect to them. The currently active connection, if there is one, is marked with an * after its name.

Examples

ij> connect 'toursDB' as tours1;
ij> connect 'newDB;create=true' as newDB;
ij(NEWDB)> show connections;
TOURS1 -        jdbc:derby:toursDB
NEWDB* -        jdbc:derby:newDB;create=true
* = current connection
ij(NEWDB)>