Deleting Existing Fields 

You can delete one or more fields from a table.

To delete one field from a table, select this line and choose Edit ® Delete field.

Procedure for Deleting Several Fields:

  1. Position the cursor on the first field you want to delete, and select it with Edit ® Select block.

    2. The field is highlighted.

  2. Position the cursor on the last field of the block to be deleted and choose Edit ® Select block.

    3. All the fields of the selected block are highlighted.

  3. Choose Edit ® Cut.

The selected block is deleted.

If you accidentally deleted fields, you can insert the entire block again with Edit ® Paste. However, this only works if you did not delete any more fields thereafter. Otherwise the buffer will have been overwritten with the last fields to be deleted. The contents of the buffer are available during several transactions.

If the table in the database already contains data, you have to convert the table after deleting existing fields (see Adjusting Database Structures).

If you delete key fields of the table, data could be lost during conversion. If the table contains data records that only differ in the deleted key field, only one of these data records can be loaded back into the table.

You cannot delete a field used as a reference field in another table. In this case you must first remove all the uses of the field as a reference field (see Reference Fields and Reference Tables).

You cannot delete key fields of the table if the table is the check table. In this case you must first delete the corresponding foreign key.

You can determine all the tables that use the particular table as a check table or reference table with Utilities ® Where-used list.