delete (core)

Removes a row from a table (cursor event). The affected row must be made current by a read cursor.

Syntax

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

Example 1 – deletes title.

delete titles where current of title_crsr

Adaptive Server/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.
Adaptive Server/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.