Declare Showplan Operator

The Declare Showplan operator allocates a local variable in the query plan. Declare is a language element.

Graphical execution plan icon

See Also

Tasks

How to: Display an Actual Execution Plan

Reference

DECLARE @local\_variable (Transact-SQL)

Concepts

Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)