Inserting rows into the database from the Interactive SQL result set  Working with SQL statements in Interactive SQL

Chapter 3: Using Interactive SQL in Graphics Mode

Deleting rows from the database using Interactive SQL

The Delete command removes the selected rows from a database table. You must have delete permission on the table to delete rows.

StepsTo delete a row from the result set:

  1. Select the row(s) you want to delete. To select a rows:

  2. Right-click the result set and choose Delete from the pop-up menu. You can also delete the selected row(s) by pressing the Delete key.

    The selected row(s) are removed from the database table.

  3. Execute a commit statement to make your changes to the table permanent.





Copyright © 2005. Sybase Inc. All rights reserved. Working with SQL statements in Interactive SQL

View this book as PDF