User guide

Managing Tables12-6
1. Choose the data type for the column by clicking on one of the
following: Char, PicX, Varchar, DateTime, Interval, Decimal, Numeric,
Pic9, Smallint, Integer, Largeint, or Float.
Depending on the data type you choose, additional attributes of
the data types can be specified. For example, if you choose
Decimal, the Length, Scale, and Signed check-boxes are
displayed in the pane.
2. Click on the appropriate check-boxes to define the attributes of the
data type.
Assign Value Attributes
Use the Defaults pane shown in Figure 12-4 to specify the default value for
the column.
Figure: 12-4. Defaults Pane.
To assign default attributes
1. If the new column should allow null values, click on NULL.
2. Choose the type of default value by clicking on one of the following:
System, User, Current, or No Default.
3. If you click on User, enter the default value in the User field.
Assign a Primary Key
Use the Key pane shown in Figure 12-5 to specify the primary key for the
column.
Figure: 12-5. Key Pane.
To assign a primary key