Deleting a Table Row in the Result Window

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Tutorials > "ZooDB" Database > Updating Database Data >

Deleting a Table Row in the Result Window

One of the veterinarians will not be available for the zoo anymore and the zoo authorities want to have his records deleted from the database. DatabaseSpy allows you to delete a row from a table with a mouse click, provided that the Result window is in the Editing mode.

 

 

To delete a row from a database table:

1.Make sure that the Result window is still in the Editing mode.
2.Click somewhere into the sixth row of the result grid and click the Delete row ic_delete-row button in the toolbar of the Result window.

tab_result-delete-veterinarian

The background color of the row as well as the text color change to indicate that this row is to be deleted from the database.

 

3.Click the ic_commit button. The row is removed from the result grid and deleted from the database.

tab_result-veterinarian-deleted


© 2019 Altova GmbH