Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Statements

DELETE statement Next Page

DELETE (positioned) statement [ESQL] [SP]

Use this statement to delete the data at the current location of a cursor.


DELETE [ FROM table-spec ] WHERE CURRENT OF cursor-name

cursor-name : identifier | hostvar

table-spec : [ owner.]correlation-name

owner : identifier


This form of the DELETE statement deletes the current row of the specified cursor. The current row is defined to be the last row fetched from the cursor.

The table from which rows are deleted is determined as follows:


Must have DELETE permission on tables used in the cursor.

Side effects


See also
Standards and compatibility

The following statement removes the current row from the database.

WHERE CURRENT OF cur_employee;