Makes a cursor inaccessible and releases all memory resources committed to that cursor.
deallocate [cursor] cursor_name
is the name of the cursor to deallocate.
Deallocates the cursor named “authors_crsr”:
deallocate cursor authors_crsr
Also deallocates the cursor named “authors_crsr,” but omits cursor from the syntax:
deallocate authors_crsr
You can use deallocate cursor with an archive database.
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.
ANSI SQL – Compliance level: Transact-SQL extension.
No permission is required to use deallocate cursor.
Commands close, declare cursor
