Columns Tab, Database Columns

Use the following information to fill each column on the Columns tab:

Field | Description
--- | ---
Name | Specify the name of the field.
Type | Use the drop-down list to select the field's type. Note: The valid values will vary, depending on the database.
Size | Specify the size of the field.
Sub-Size | Specify the sub-size of the field.
Allows Null | Specify if this field can be null.
Unique | Specify whether the value must be unique within the table.
Primary Key | Specify whether or not this field is a primary key for the table (see "Setting a Primary Key for Database Tables").
Identity | Use to indicate a Sybase, SQL Server or Informix identity field.

Note: Some properties may be unavailable, depending on your database type.

To add a new field, click Add.

To remove a field, select the field and click Remove.

To rename a field, select the field and click Rename.

See Also

  Working With Database Tables in the Editor Window
  Setting a Primary Key for Database Tables