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

System Stored Procedures (Transact-SQL)