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:

  1. Navigate to the table by expanding Database > Schemas > SAMPLELIB > Tables.

  2. In the detail pane, right-click INVENTORY_LIST and select Definition.

  3. In the Table Definition window, click the Columns tab and click Add.

  4. 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

  5. Click OK to add these columns.

 

Parent topic:

Creating a table and defining a column