Removes a row from a table (cursor event). The affected row must have been made current by a read cursor.
Transact-SQL Syntax
delete [from][[database.]owner.]{table_name | view_name}
where current of cursor_name
ODBC Syntax
DELETE FROM table_name WHERE CURRENT OF cursor_name
delete titles where current of title_crsr
ASE/CIS issues a cursor delete request if it examines any column data to fulfill the client request. This is true when:
More than one table is involved in the delete statement.
The statement contains built-in functions in the where clause.
ASE/CIS passes the delete command to the DirectConnect server as this series of cursor commands:
declare
open
close
deallocate
The where clause is not constructed. Open Server appends the equivalent of where current of cursor read_cursor_name.
The cursor can be reused multiple times before it is deallocated.
When the DirectConnect server calls srv_senddone to mark the completion of the delete command, the number of affected rows must be indicated. Normally, the row count is 1.
Any valid object in the catalog can be substituted for table_name or view_name.
