Table window : Clear/Delete selection

Table window	Edit menu
Clear/Delete

Clear or delete a selection of fields, columns or records in a table.

To delete a selection:

choose Delete from the Edit menu,
click the Delete button in the toolbar,
press the Del key on the keyboard, or
click the selection with the right mouse button, and choose Delete from the context-sensitive menu.

Notes:

When deleting the contents of selected fields: the contents of fields of dependent columns cannot be deleted, as these 'values' are the result of a calculation or a column operation.
When deleting columns: read-only columns and table-owned columns cannot be deleted.
When clearing or deleting parts of a table, all changes are directly stored on disk.
You CANNOT UNDO a clear or a delete.

To clear the contents of selected fields:

Select the fields you wish to clear:

To select a single field: click the single field you wish to clear.
To select multiple fields in sequence:

drag a rectangle over the block of fields you wish to clear,

click the first field you wish to clear,
then press the Shift key and hold it down, and
select the last field of a sequence of fields that you wish to clear.

Use one of the Clear/Delete methods described above.

Before the selected field(s) are actually cleared, a confirmation is asked.

To delete one or more selected columns:

Select the column(s) you wish to delete:

To select a single column: click the single column you wish to delete.
To select multiple columns in sequence:

click the first column of a sequence of columns you wish to delete,
then, press the Shift key on the keyboard and hold it down, and
click the last column of a sequence of columns that you wish to delete.

Use one of the Clear/Delete methods described above.

Before the selected column(s) are actually deleted, a confirmation is asked.

Tip: Before deleting a number of columns, you may wish to first re-order your columns. To change the position of a column in the table, drag a column header to a new position. The mouse pointer will change into a column icon while dragging.

To clear the contents/to delete one or more selected records (rows):

When a table uses a Class or ID domain, the contents of selected record(s) will be cleared.

When a table uses system domain None, the selected record(s) will be deleted. After the deletion, the remaining records will be renumbered.

Select the records you wish to delete:

To select a single record: click the record button of the record you wish to clear/delete.
To select multiple records in sequence:

keep the left mouse button down while moving over the record buttons of the records that you wish to delete,

click the first record button of a sequence of records that you wish to delete,
press the Shift key on the keyboard and hold it down,
click the last record button of a sequence or records that you wish to delete.

Use one of the Clear/Delete methods described above.

Before the selected record(s) are actually cleared or deleted, a confirmation is asked.