Deleting Fields

You can delete an existing field from a table with the Table Designer or with the language.

To delete a field from a table

• In the Table Designer, select the field and choose Delete.

  -or-

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

For example, the following command drops the field called fax from the customer table:

ALTER TABLE customer DROP COLUMN fax 

Removing a field from a table also removes the field's default value setting, rule definitions, and caption. If index key or trigger expressions reference the field, the expressions become invalid when the field is removed. The invalid index key or trigger expression will not generate an error until run time.

See Also

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