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.