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.
DEALLOCATE cursor_name
where