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 Database Pilot.
Type the name of the new table in this field.
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. |
To create the table columns,
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 statement manually, click the Edit 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 table's columns in the Create Table dialog box.