Reference Manual Volumes 1 - 4 (Online Only)

Description

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

deallocate cursor cursor_name

cursor_name

is the name of the cursor to deallocate.

Example 1

Deallocates the cursor named "authors_crsr":

deallocate cursor authors_crsr

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

SQL92 - Compliance level: Transact-SQL extension.

deallocate cursor permission defaults to all users. No permission is required to use it.


	Expand Search