Execution Warnings

This feature of SQL Complete analyzes the script to be executed for DELETE, DROP, TRUNCATE, and UPDATE statements and produces a blocking message if the statements are used in certain types of environments. For example, the message will be prompted is you try to execute a DELETE statement against a production database.

To configure the behavior of execution warnings:

  1. Go to Options in the SQL Complete menu.
  2. In the left pane of the Options window, click Execution Warnings.

Execution Warnings

In the Exacution Warnings window, you can specify the maximum script size to analyze and enable execution warnings for certain environments.

Note:

SQL Complete analyzes every USE statement and prompts an execution warning if the statement refers to a database of the environment for which the execution warning is set.