Create Table dialog box

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

Table Name

Type the name of the new table in this field.

Table Locale

Stores the Locale object to use for formatting a Column. Locale contains country or area-specific formatting specifications such as date format (MM/DD/YY, DD/MM/YY, YY/MM/DD), currency symbol, and so on. Select a Locale from the drop-down list.

Resolvable

Checking this indicates that the table would be resolvable, for example, whether changes made to the table would be tracked so that they could later be resolved against another database.

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 column property fields on that row you want to define, and select or enter a value. For each column, you must specify at least a column name and data type. You may also specify other properties as needed.

    See the Column class for a description of the meaning of the Column properties.

  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 finshed creating and defining all the columns.