Adding columns when creating a table

Use the Columns page of the Create Table notebook to add columns to your table. You can add new columns to your table and change, remove, or rearrange the new columns. After the table is created, you must use the Alter function to add or change columns.

Fields and controls



To add new columns:

  1. Click on the Columns tab.

  2. Click on Add. The Add Column window opens.

  3. In the Column name field, type a name for the column that you're adding.

  4. Use the Data type box to specify the data type of the column that you're adding.

  5. If you specified a data type of CHARACTER, VARCHAR, BLOB, CLOB, DBCLOB, GRAPHIC, or VARGRAPHIC, type the length (byte count) of the column that you're adding in the Length field.

  6. If you specified a data type of BLOB, CLOB, or DBCLOB, use the LOB unit box to specify a multiplier for the length of columns.

  7. If you specified a data type of DECIMAL:

    1. In the Precision field, type the precision (total number of digits) for the column.

    2. In the Scale field, type the scale (number of digits to the right of the decimal) for the column.

  8. If you specified a data type of BLOB, CLOB, DBCLOB, or a distinct type with any of these as source types, specify the LOB options by selecting or clearing the appropriate LOB option check boxes.

  9. Optional: If you specified a data type of CHARACTER, VARCHAR, or LONG VARCHAR, select the Bit data check box to specify that the contents of the column be treated as bit (binary) data.

  10. Optional: In the Default field, type a default value for the column.

  11. If you want to allow the column to contain null values, select the Nullable check box.

  12. Optional: In the Comment field, document the column that you're adding.

  13. Click on Add to add the new column.

  14. Repeat steps 3 through 13 to add another column to your table. You can add up to 500 columns to your table.

  15. Click on Close to close the Add Column window.

  16. If you do not want to define a primary key, foreign keys, or check constraints, click on OK to create your table and close the Create Table notebook. Otherwise, continue on to one or more of the optional tasks.


Related information