T-SQL Code Analyzer Tool

dbForge Studio for SQL Server provides a fast and automated way to improve the quality of your code. With help of T-SQL Analyzer, you can eliminate potential design and naming problems and avoid performance pitfalls by analyzing your T-SQL code.

With help of T-SQL Analyzer, you can:

  • Identify possible SQL statement defects
  • Check T-SQL code for compliance with best practices
  • Customize code analysis profiles

Analyzing code

In order to analyze your 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 the Analyze Code button.
Calling T-SQL Analyzer

Error list

When code in the database instance is analyzed, warnings and errors, if any, will appear in the Error List. To determine the error or warning location within the code, right-click the error or warning, and then select Go to Error from the shortcut menu. To get more information on each entry, click the error code that is highlighted in blue. You will be taken to a corresponding page in our documentation.

Analyzed Code

Customizing code analysis rules

To configure different sets of code analysis rules, run a smaller set of rules, or create your own rules, go to the Tools menu, select Options, and then click Code Analysis.

Code Analysis Rules