How to analyze 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. With help of T-SQL Analyzer, you can eliminate potential design and naming problems and avoid performance pitfalls by analyzing your T-SQL code.
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
- Open the database instance, containing the code you want to analyze.
- 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.
Customize 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.
Want to Find out More?
Overview
All features
Request a demo
