Create Table dialog box

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.

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:

firstrow.gif Selects the first row.
priorrow.gif Selects the prior row
nextrow.gif Selects the next row.
If there is not a next row, it creates one after the current one.
lastrow.gif Selects the last row.
insertrow.gif Inserts a row before the currently selected row.
deleterow.gif Deletes the currently selected row.
up.gif Moves the selected row up one row.
down.gif Moves the selected row down one row.

Column names and parameters

To create the table columns,

  1. Create a new row by clicking either the Insert Row, or Move Forward button on the Navigation Bar.
  2. Click in the Column name field and type the name of the new column.
  3. 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.
  4. Continue creating the rest of the columns in this manner, rearranging their order in the table as desired.
  5. Click OK when you are finished 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 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.