# Set Connection

#### Syntax

    SET CONNECTION Identifier

#### Description

Allows you to specify which connection to make current when you have more than one connection open. Use the Show Connections command to display open connections.

If there is no such connection, an error results and the current connection is unchanged.

#### Example

    ij> protocol 'jdbc:derby:';
    ij> connect 'sample' as sample1;
    ij> connect 'newDB;create=true' as newDB;
    ij (NEWDB)> show connections;
    SAMPLE1 -    jdbc:derby:sample
    NEWDB* -    jdbc:derby:newDB;create=true
    * = current connection
    ij(NEWDB)> set connection sample1;
    ij(SAMPLE1)> disconnect all;
    ij>

Parent topic: ij commands and errors reference
Related concepts
ij commands
ij errors
Related reference
Absolute
After Last
Async
Autocommit
Before First
Close
Commit
Connect
Describe
Disconnect
Driver
Elapsedtime
Execute
Exit
First
Get Cursor
Get Scroll Insensitive Cursor
Help
Last
LocalizedDisplay
MaximumDisplayWidth
Next
Prepare
Previous
Protocol
Readonly
Relative
Remove
Rollback
Run
Show
Wait For
Comment
Identifier
String