The Create Statement Dialog

 

 

The CREATE statement is opened from the connection dialog by creating a statement on a connection, refer to .

 

When this window is opened we are presented with one line only. Namely the line pointed to by number (1). The first step is to specify a name for the new table and then hit the '+ Column' so that a new column definition is created below the table. From there on out we can specify many columns, each with its own data type and constrains.

For instance, for the column ID pointed to by (2) we have specified that it is an UNIQUE INTEGER. As with the SQL CREATE statement we can specify collation (like charset or locale encoding), a default value, different types of constraints (like REFERENCES- number (4)) and size if it is applicable.

The create statement is shown in the panel pointed to by (5). At the end of the process we can verify the SQL statement with the 'CodeIt!' button. After the code is generated there are 2 options for creating the table and columns specified.  Either we use the 'Create' button to execute the statement, which should directly create the table specified, or we can paste the code into our JAVA application and run it from there together with the dbJAPI library.