Adding Fields

  • Article

You can add a new field to a table with the Table Designer or with the language.

To add a field to a table

  1. In the Table Designer, choose Insert.

  2. In the Name column, type the name of the new field.

  3. In the Type column, select a data type for the field.

  4. In the Width column, set or enter a width for the field.

  5. If the field has a type of Numeric or Float, set the number of decimal places in the Decimal column.

  6. If you want the table to accept null values, select the NULL column.

  7. Choose OK.

  8. Choose Yes to make the table structure changes.

    -or-

  • Use the ADD COLUMN clause of the ALTER TABLE command.

For example, the following command adds a field called fax to the customer table and allows the field to have null values:

ALTER TABLE customer ADD COLUMN fax c(20) NULL

See Also

Modifying the Table Structure | Deleting Fields | Working with Tables | Renaming Fields | Setting or Changing Field-Level or Table Rules