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
As with the previous example, also deallocates the cursor named “authors_crsr”, but omitting cursor from the syntax:
deallocate 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.
ANSI SQL – Compliance level: Transact-SQL extension.
deallocate cursor permission defaults to all users. No permission is required to use it.
Commands close, declare cursor
Copyright © 2005. Sybase Inc. All rights reserved. |