deallocate cursor

Makes a cursor inaccessible and releases all memory resources that are committed to that cursor.

Syntax

deallocate [cursor] cursor_name

Parameters

cursor_name – is the name of the cursor to deallocate.

Examples

Example 1 – Deallocates the cursor named “authors_crsr”:
```
deallocate cursor authors_crsr
```
Example 2 – Also deallocates the cursor named “authors_crsr,” but omits cursor from the syntax:
```
deallocate authors_crsr
```

Usage

You can use deallocate cursor with an archive database.
The SAP ASE server returns an error message if the cursor does not exist.
You must deallocate a cursor before you can use its cursor name as part of another declare cursor statement.
deallocate cursor has no effect on memory resource usage when specified in a stored procedure or trigger.
You can deallocate a cursor whether it is open or closed.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

No permission is required to use deallocate cursor.

Parent topic: Commands

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com