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.

To delete several fields at one time, proceed as follows:
    1. Position the cursor on the first field you want to delete and select it with Edit ® Select block.
    2. Position the cursor on the last field of the block to be deleted and choose Edit ® Select block. 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 whole block again with Edit ® Paste. However, this only works if you did not delete any further 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 on the database already contains data, you have to convert the table after deleting existing fields.

If you delete key fields of the table, data could be lost during conversion. If the table contains data records which 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 delete all the uses of the field as a reference field (see Reference Field and Reference Table).

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 which use the particular table as a check table or reference table with Utilities ® Where-used list.