The Execution Warnings window allows you to choose whether you want to see warnings when executing DELETE, UPDATE, and TRUNCATE statements without the WHERE clause.
When showing the warnings window, the following information will be displayed:
Row number in the executed script corresponding to the expression’s beginning.
The Execution Warnings window looks the following way:
Warning providers are supported on different levels - they include separate query analysis and the DML analysis of procedure, function, and trigger bodies. Document category and its specific notification rules are used when the script is checked.
To access the Execution Warnings settings, proceed with the following steps:
The Execution Warnings settings window looks the following way: