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

handle

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

Related content

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