DEALLOCATE Statement

Removes the cursor data structures. DEALLOCATE is different from CLOSE in that a closed cursor can be re-opened. DEALLOCATE releases all data structures associated with the cursor and removes the definition of the cursor.

Syntax

DEALLOCATE cursor_name

where

cursor_name
Specifies the name of an already-declared cursor.