EMS logo

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for InterBase/Firebird

On-line Documentation

Selecting options for data deleting


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

 

Purge Database - Selecting options for data deleting

 

CheckBox 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.

 

CheckBox Recompute statistics of table indices after data deletion

Use this option to recompute statistics after deleting data.

 

CheckBox Sweep database after data deletion

Use this option to sweep the database after deleting data.

 

CheckBox 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.