Deleting Records

If you have delete privileges, you can delete records from within the database browser. There are several methods available to you, depending on how many records you need to delete. Remember that you cannot undo a deletion.

On This Page

• Delete One Record
• Delete Adjacent Records
• Delete Non-Adjacent Records
• Delete a Large Number of Records
• Delete by Query
• Delete by Record ID Range

Delete One Record

To delete one record:

1. Select the record.
2. Click the DELETE key or right-click and choose Delete Selected.
3. Click Yes to confirm the deletion.

Delete Adjacent Records

To delete or more adjacent records:

1. Click a row with the mouse, then press and hold the SHIFT key,  then click the last row that you want to delete.

2. Press the DELETE key, or right-click and choose Delete Selected.
   A prompt will appear to confirm that you want to delete these records.

3. Click Yes to confirm the deletion, or No to cancel.

Delete Non-Adjacent Records

To delete several records that are not adjacent to each other:

1. Click a row with the mouse, then press and hold the CTRL key, and then the other rows that you want to delete.

2. Press the DELETE key, or right click and choose Delete Selected.
   A prompt will appear to confirm that you want to delete these records.

3. Click Yes to confirm the deletion, or No to cancel.

Delete a Large Number of Records

To delete a large number of rows, we recommend that you use the Bulk Delete feature, which gives you two options: delete by Query or delete by Record ID Range.

Delete by Query

Follow these steps to delete by query:

1. In the top toolbar of the Database Browser, click the Bulk Delete item to display the bulk deletion wizard.

2. In the Delete Mode drop-down, choose Query and then click the Edit Query / Selection button to display the Rules panel.

3. You can add one or more filters that evaluate the values in the fields that you choose.

4.  You can then set the Matching Options in the upper left corner of the Rules panel.

5. Click the Preview Filter Results button to see which records will be deleted.

6. Click Save to commit the filters-or Cancel to exit and return to the bulk deletion wizard,

7. Click the Delete Records button. Then click Yes to confirm, or No to cancel.

Delete by Record ID Range

Follow these steps to delete by record ID range:

1. In the top toolbar of the Database Browser, click the Bulk Delete item to display the bulk deletion wizard.

2. In the Delete Mode drop-down, choose Record ID Range.

3. Then, enter the start and end of the Record ID Range that covers all of the records you want to delete.

4. Click the Delete Records button. Then click Yes to confirm, or No to cancel.