sp_cursorunprepare (Transact-SQL)

Applies to: SQL Server

Discards the execution plan developed in the sp_cursorprepare stored procedure. sp_cursorunprepare is invoked by specifying ID = 6 in a tabular data stream (TDS) packet.

Transact-SQL syntax conventions

Syntax

sp_cursorunprepare handle
[ ; ]

Arguments

Important

Arguments for extended stored procedures must be entered in the specific order as described in the Syntax section. If the parameters are entered out of order, an error message occurs.

handle

The handle value returned by sp_cursorprepare when the statement is prepared.

Related content

• sp_cursorprepare (Transact-SQL)
• System stored procedures (Transact-SQL)