Insert Column

Insert a new column (field) into a table.

 

Purpose

Action

Name

The name of the field.

Type in a name up to 24 characters in length.

See Attribute Naming Convention.

Type

Selects the data type: numeric or alphanumeric.

Select a value.

Length

The width of an alphanumeric field (the maximum number of characters it can contain).

Type in the number of characters.

Default Value

Give the field a default value if required.

Set a default value to be used in the absence of other data.

Implicit

Sets whether the column (field) has a single value for all records (implicit) or whether its value is different for each record.

Select a value.

Formula

Define the formula for creating a new column's (field's) values.

Type in a formula or use the browse button to display the Edit Formula screen.

Related topics and activities