You can also delete rows from a database table in Interactive SQL. You must have DELETE permission on the table to delete rows.
To delete a row from the result set
Select the row(s) you want to delete. To select a row(s):
If you want to delete non-consecutive rows, you must delete each row individually.
The selected row(s) are removed from the database table.
Execute a COMMIT to make the change permanent.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|