Connect command of ij to establish a connection with a database

The connect command loads a JDBC driver to establish the connection.

The command to establish a connection with a sample database is:

connect "jdbc:derby:sample";

Working with Tables

Use the Create Table SQL command to create a new table in a database.

Create table employee (name varchar(30),address varchar(50));