SQL Complete generates aliases automatically for tables, views, table-valued functions, and synonyms. You can rename the default aliases directly in the code and all references to the renamed aliases will be automatically correct to the relevant ones.
This feature allows you to improve code readability by giving meaningful and self-explaining names to tables, columns, temporary tables and columns, views, stored procedures, and functions. SQL Complete will automatically correct all references to the renamed objects.
With the help of the rename functionality, you can also change the names of local and SQLCMD variables in a few seconds. Preview code changes in a convenient tree-view of the Rename dialog window.
When you type code, don't bother to correctly place semicolons after each specific statement. The Insert Semicolons option does this for you – it inserts missing semicolons after each statement in a query in one click.
As you develop code, this functionality automatically adds square brackets around identifies where needed.
T-SQL Debugger allows investigating the run-time behavior of database objects and locating logic errors. One can also benefit from the support for step-by-step execution, call stack browsing, breakpoints, and watches.
With this functionality, you can simply detect and fix invalid objects that often appear during database development process. Search for objects that cannot be compiled or executed just in a few clicks as well as generate effective scripts to manage them. The functionality provides the following opportunities:
You can automate regular search for invalid objects from the command line. To do that, select the required database and click Save Command Line on the toolbar. In the Command line execution file settings window that opens, you will see that the script has been auto-generated for the selected database.
You can save this script to a .bat file that can be reused at any given moment; simply click Save, provide a name and destination for the file, and click Save again. Now, whenever you launch the saved file, the search for invalid objects will be performed in a matter of moments.
We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.