Delete 100 Customers

We have seen how easy it is to create 100 Customers, so lets delete them. After all, we can easily recreate them simply by selecting the previous scenario and pressing the Generate button on the toolbar.

• Close all dialogs to return to the TurboData primary window.
• Press the Delete Data tab.

  

• From the Scenario menu, select the New Scenario option.
• Enter the Name 'Delete Customers', and press OK.

  

• The Edit Delete Data Scenario dialog will be opened automatically. Click on the Customer table, keep the mouse button down, and drag the arrow icon over to the right hand tree. Release the mouse button.

  

• Note: This scenario will delete ALL the Customer data from the database. To be more selective you could add text in the Where Clause, for example 'WHERE ID1 <= 100'
• Press the Generate push button to open the Generate SQL dialog

  

• Click on the Update Database option
• Press the Generate push button to Generate the Delete SQL statements and automatically delete the data from the target database.
• Answer Yes to the confirmation question.

  

• Press the View Data on Target DB push button to open the Edit Data dialog. Select Customer from the Table drop down list, and you will see that the 100 Customers we just created have been deleted!