sp-cursorunprepare-transact-sql.md

title	sp_cursorunprepare (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql
ms.prod_service	database-engine
ms.reviewer
ms.technology	system-objects
ms.topic	language-reference
f1_keywords	sp_cursorunprepare_TSQL sp_cursorunprepare
dev_langs	TSQL
helpviewer_keywords	sp_cursorunprepare
ms.assetid	b46d4813-c4a9-4f9d-9979-2b5082ecf06a
author	stevestein
ms.author	sstein

sp_cursorunprepare (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-xxxx-xxxx-xxx-md]

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
Is the handle value that is returned by sp_cursorprepare when the statement is prepared.

See Also

sp_cursorprepare (Transact-SQL)
System Stored Procedures (Transact-SQL)