sp_unprepare (Transact-SQL)

Discards the execution plan created by the sp_prepare stored procedure. sp_unprepare is invoked by specifying ID = 15 in a tabular data stream (TDS) packet.

Syntax

sp_unprepare handle 

Arguments

• handle
  Is the handle value returned by sp_prepare.

See Also

Other Resources

sp_prepare (Transact SQL)

System Stored Procedures (Transact-SQL)