Online Documentation for SQL Manager for InterBase/Firebird

Selecting options for data deleting

This step of the wizard allows you to select the options and rules for deleting data.

Temporarily deactivate table triggers before data deletion

Use this option to disable triggers before deleting data. After the data has been deleted, the trigger will be automatically activated.

Recompute statistics of table indices after data deletion

Use this option to recompute statistics after deleting data.

Sweep database after data deletion

Use this option to sweep the database after deleting data.

Temporarily change delete rules of foreign keys referring to the purging table

Use this option to change delete rules for foreign keys linked to the selected tables. You can choose the new rule: SET NULL, SET DEFAULT or CASCADE.

Click < Back to go back to Selecting database and execution mode step or Next > to proceed to the Selecting tables to purge data step.