Create Table dialog
Use the Create Table dialog box to create a database table and define its columns visually. To open this dialog box, choose File|Create Table in the JDBC Explorer.

Table Name
Type the name of the new table in this field.
Navigation bar
Use the Navigation bar to add or delete rows, or to change their order. The buttons on the Navigation Bar do the following:
 |
Selects the first row. |
 |
Selects the prior row |
 |
Selects the next row. If there is not a next row, it creates one after the current one. |
 |
Selects the last row. |
 |
Inserts a row before the currently selected row. |
 |
Deletes the currently selected row. |
 |
Moves the selected row up one row. |
 |
Moves the selected row down one row. |
Column names and parameters
To create the table columns,
- Create a new row by clicking either the Insert Row, or Move Forward button on the Navigation Bar.
- Click in the Column name field and type the name of the new column.
- Click in each of the parameter fields on that row you want to define, and select or enter a value. The data type column has a drop-down that lists all the data types specific to the database server to which you are connected. You must select or enter values that generate a SQL statement that is valid for that server.
- Continue creating the rest of the columns in this manner, rearranging their order in the table as desired.
- Click OK when you are finshed creating and defining all the columns.
SQL statement
As you specify each column and its parameters, the SQL statement for creating them is automatically generated and displayed in the SQL edit field at the bottom of the dialog box. While you are designing the columns visually, editing in the SQL field is disabled.
To modify the SQL statment manually, click the SQL button. The SQL field at the bottom becomes an active editor.
Note: If you edit the SQL manually, you will no longer be able to visually define and edit this tables columns in the Create Table dialog box.