1.1

If there is no such connection, an error results and the current connection is unchanged.
Example
sqlf(PEERCLIENT)> set connection clientConnection;
sqlf(CLIENTCONNECTION)> show connections;
CLIENTCONNECTION* - jdbc:sqlfire://localhost:1527/
PEERCLIENT - jdbc:sqlfire:
* = current connection
sqlf(CLIENTCONNECTION)>
show
Displays information about active connections and database objects.
Syntax
SHOW
{
CONNECTIONS |
INDEXES [ IN schemaName | FROM table-Name ] |
PROCEDURES [ IN schemaName ] |
SCHEMAS |
SYNONYMS [ IN schemaName ] |
TABLES [ IN schemaName ] |
VIEWS [ IN schemaName ] |
}
Description
Displays information about active connections and database objects.
SHOW CONNECTIONS
If there are no connections, the SHOW CONNECTIONS 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 is marked with an * after its name.
Example
sqlf(CLIENTCONNECTION)> show connections;
CLIENTCONNECTION* - jdbc:sqlfire://localhost:1527/
PEERCLIENT - jdbc:sqlfire:
* = current connection
sqlf(CLIENTCONNECTION)>
SHOW INDEXES
SHOW INDEXES displays all the indexes in the database.
If IN schemaName is specified, only the indexes in the specified schema are displayed.
If FROM table-Name is specified, only the indexes on the specified table are displayed.
Example
sqlf(PEERCLIENT)> show indexes in app;
TABLE_NAME |COLUMN_NAME |NON_U&|TYPE|ASC&|CARDINA&|PAGES
----------------------------------------------------------------------------
AIRLINES |AIRLINE |false |3 |A |NULL |NULL
445
sqlf Interactive Commands