Analyzing T-SQL Code

dbForge Studio provides a fast and automated way to ensure that your T-SQL code fits to your predefined design and style guidelines as well as best coding practices.

Before you analyze your code, you might want to configure the rules that will run as part of the analysis. To configure different sets of rules, run a smaller set of rules, or create your own rules, see Code Analysis Options.

To Analyze Code

  1. Open the database instance, containing the code you want to analyze.
  2. Right-click anywhere on the document, and then select Analyze Code from the shortcut menu. Alternatively, on the Text toolbar, click Analyze Code.

The code in your database instance is analyzed, and any warnings and errors appear in the Error List.

To navigate to error or warning location within the code, right-click the error or warning, and then select Go to Error from the shortcut menu.