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
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.
Commands close, declare cursor