Improve code quality

Last modified: October 28, 2024

SQL Complete offers conveniently accessible refactoring tools that help enhance code quality, make it easier to understand, and improve the design of code objects and entire databases.

The key feature of SQL Complete is T-SQL Debugger designed to troubleshoot Transact-SQL scripts, stored procedures, triggers, and functions. The debugger allows observing the runtime behavior of database objects and locating logic errors. The tool supports step-by-step execution, call stack browsing, breakpoints, and watches. The user can break or suspend the execution of a program to examine a database object, as well as evaluate and edit variables in scripts directly in the IDE.

Other essential features include:

• Rename objects: SQL Complete helps safely rename database objects including the temporary ones without breaking dependencies. The tool will automatically find and correct all references to the renamed objects.
• Rename variables: With SQL Complete, you can quickly rename all variables in a SQL script. The tool finds, highlights, and renames all uses of the specified variable automatically to make your code cleaner and more readable.
• Rename aliases: You can use SQL Complete to rename all occurrences of an alias in a query.
• Find invalid objects: SQL Complete allows you to find invalid objects (e.g. those that reference non-existing objects) in multiple databases.

Video tutorial

Watch the following video to learn how to perform code refactoring in SQL Complete.