You can define columns on a new or existing table. To add columns
to the table you just created, navigate to the table INVENTORY_LIST by expanding . In the detail pane, right-click
the table INVENTORY_LIST and select Definition.
- To define a column on the Table Definition window, select the Columns tab.
- Click Add.
- Add the following columns to Table INVENTORY_LIST:
| Column name |
Type |
Length |
Precision |
Scale |
Nullable |
Default value |
|---|
| ITEM_NAME |
VARCHAR |
20 |
|
|
No |
UNKNOWN |
| UNIT_COST |
DECIMAL |
|
8 |
2 |
No |
0 |
| QUANTITY_ON_HAND |
SMALLINT |
|
|
|
Yes |
NULL |
| LAST_ORDER_DATE |
DATE |
|
|
|
Yes |
NULL |
| ORDER_QUANTITY |
SMALLINT |
|
|
|
Yes |
20 |
When you finish defining these columns, click
OK to
create the table.