Defining additional columns on a table
After you create a table, you can still add new columns to the table. To add columns to the INVENTORY_LIST table that you created, follow these steps:
- Navigate to the table by expanding Database > Schemas > SAMPLELIB > Tables.
- In the detail pane, right-click INVENTORY_LIST and select Definition.
- In the Table Definition window, click the Columns tab and click Add.
- Define the following new columns.
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
- Click OK to add these columns.
Parent topic:
Creating a table and defining a column