The ij tool enables you to connect to a running JavaDB server and execute scripts and queries against a database.
Command | Description |
Driver | Loads the specified JDBC driver. |
Protocol | Sets the specified protocol to use for connecting to a database. |
Connect | Establishes a connection with a database. |
Set Connection | Switches from the existing connection to a different connection specified with a connection name. |
Show Connections | Lists all active connections. |
Disconnect | Disconnects the current connection, a connection specified by a connection name, or all active connections. |
Show Schemas | Lists all schemas present in the current database. |
Show Tables | Lists all tables present in the current database. |
Show Views | Lists all views present in the current database. |
Show Procedures | Lists all stored procedures present in the current database. |
Show Indexes | Lists all indexes present in a specified table. |
Describe | Displays information about columns, such as column name and data type, for a specified table. |
Commit | Commits the current transaction. |
Rollback | Rolls back the current transaction. |