Skip Headers

# Working With Column Properties

Previous

Next

Use the database table's Column tab to specify properties for the database table's fields.

To specify a table's column properties, use this procedure:

1. Select a database table in the Navigator. The table's property sheet displays in the Editor.

2. Click the Columns tab.

3. Enter data in each field on the Columns tab. Use the scroll bar to display the additional field.

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