The Create table page provides a simple way for you to define a table and create it in the database. You can fill in the names and types of up to 10 columns in the table (any columns you leave blank will not be put into the table). The column types are expressed in JDBC types, which may or may not correspond directly to your database’s data types.

The Nullable, Unique, and Primary Key flags indicate properties of the column. You’ll have to be careful to avoid illegal combinations; for example, most databases do not allow a primary key to be nullable.

The Additional Constraints are passed straight through to the CREATE TABLE statement. This allows you to enter additional constraints, such as foreign keys or indices.

loading table of contents...