Appendix C: Using Sybase Mode Commands

delete (cursor command)

Using a cursor command, delete removes a row from a table. The row affected must have been made current by a read cursor.

1. delete [[database.]owner.]{table_name | view_name}

2. delete [from] [[database.]owner.]{table_name|view_name}
 	where current of cursor_name

Any valid object in the catalog can be substituted for table_name or view_name.

from (after delete): is an optional keyword used for compatibility with other versions of SQL. Follow it with the name of the table or view from which you want to remove rows.

declare c1 cursor for
 select * from tablea for update of col1

delete tablea where current of c1

The cursor can be reused multiple times before it is deallocated.