Database objects

SQL statements and queries are used to create and update database objects. You can use these statements to create, update, or retrieve tables, indexes, foreign keys, and publications in your database. Schema information can be created with the Connection.prepareStatement and PreparedStatement.executeQuery methods.

Example

The following example illustrates how to use SQL statements to create a table:

static String stmt_1 = "CREATE TABLE Department("
    + "id INT PRIMARY KEY, "
    + "name CHAR(50) NOT NULL)";

static String stmt_2 = "CREATE TABLE Employee("
    + "id INT PRIMARY KEY, "
    + "last_name CHAR(50) NOT NULL, "
    + "first_name CHAR(50) NOT NULL, "
    + "dept_id INT NOT NULL, "
    + "NOT NULL FOREIGN KEY(dept_id) "
    + "REFERENCES Department(id))";

static String stmt_3 = "CREATE INDEX ON Employee(last_name, first_name)";

void createDb(Connection connection) throws ULjException {
    PreparedStatement ps;
    ps = connection.prepareStatement(stmt_1);
    ps.execute();
    ps.close();
    ps = connection.prepareStatement(stmt_2);
    ps.execute();
    ps.close();
    ps = connection.prepareStatement(stmt_3);
    ps.execute();
    ps.close();
}

In this example, the createDb method uses SQL statement strings to prepare and execute statements, which create two tables and an additional index on last_name and first_name.

Discuss this page in DocCommentXchange.

Database objects

See also

Example