DEALLOCATE Cursor Deallocate a cursor in a stored procedure. Syntax DEALLOCATE cursor_name Description This deallocates the cursor within a stored procedure. After performing a deallocate it is possible to redeclare the cursor using the same cursor name. Parameters cursor_name The name that was associated with the cursor using DECLARE. CLOSE Cursor Examples Using Cursors