Devart dbForge SQL Complete Pro Edition v22.214.171.124
dbForge SQL Complete provides a wide range of code completion features that relieve users from memorizing long and complex object names, column names, SQL operators, etc. Instead, it allows concentrating...
dbForge SQL Complete provides a wide range of code completion features that relieve users from memorizing long and complex object names, column names, SQL operators, etc. Instead, it allows concentrating on writing high-quality SQL code with correct formatting that is easy to understand and interpret. On this page, you will find a comprehensive list of features available in dbForge SQL Complete.
SQL Complete is an advanced solution for SQL database development, management, and administration. Available as an add-in for Visual Studio and SSMS, the tool offers excellent autocompletion capabilities. Write, beautify, refactor your SQL code easily and boost your productivity dramatically due to the features that are included in SQL Complete but are lacking in Management Studio and Visual Studio IntelliSense.
Speed up SQL query writing with IntelliSense-style SQL code completion
Beautify T-SQL code and unify code standards with a smart SQL Formatter
Get the essential information on DB objects while you are writing code
Format your SQL queries directly in SSMS or Visual Studio
Use rich SQL code snippet collection, manage and modify the existing snippets or create your own templates
Navigate through SQL documents easily and synchronize them with the code
Rename tables, columns, procedures, and functions safely with automatic correction of references to the renamed objects
Boost your productivity significantly with convenient tabs and windows, as well as intuitive management of SQL statements
SQL Code Completion
Enhance code accuracy and quality, as well as simplify the process of creating SQL queries with the following features:
Context-based code completion
Code completion for CTE
Table name autocompletion
The add-in will take care of autocompleting your SQL queries so that you can stay focused on how your code actually works.
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.
Finding invalid objects
You can also change the names of local and SQLCMD variables in a couple of seconds. Preview code changes in a convenient tree-view of the Rename dialog window. With the SQL Complete tool, SQL code refactoring becomes easy and seamless.
Boost your productivity when creating, refactoring, modifying, and beautifying the code using a rich set of features:
Data Grid commands
Jump between queries
Jump between COLUMNS and VALUES in the INSERT statement
Ease of navigation, instant access to database object definitions, and other advanced options greatly facilitate the design and formatting of SQL statements.
SQL Code Formatting
Create new formatting profiles or customize the existing ones to meet your needs. Fine-tune your formatting style to easily improve code readability and introduce unified code formatting standards within your company.
Formatting in files and directories
Disabling formatting for a certain part of the code
With the SQL script formatter, you can work with either new or existing code. Try the online SQL Formatter without having to download or install anything!
See the differences in code before and after formatting
SQL Complete helps users create, customize, and switch between formatting styles, share them with their colleagues, as well as manage and easily format SQL scripts by applying various formatting options.
Intelligent SQL completion and suggestion
Context-sensitive suggestion of keywords
Context-sensitive object suggestions
Context-sensitive object suggestions for T-SQL code, DDL, and security statements
Context-sensitive object suggestions for common table expressions (CTE)
Context-sensitive object suggestions in SQLCMD mode
Name suggestions for objects on linked servers
Sorting suggested keywords by relevance
JOIN clause auto generation
Disable/Enable Code Completion
Semi-transparent view of the suggestion box
Auto-generation of table aliases
Custom alias mapping
Column picker for quick list building
INSERT, EXEC, ALTER and UPDATE statements expansion
Recently closed documents
Exclude databases from suggestion
Highlight occurrences of an identifier
Highlight of matching columns in the INSERT statement
Column name in the values area for INSERT statement
Parameter information for functions
Quick object information
Rows Count information
ON condition suggestion for JOIN
Reverse ON condition suggestion for JOIN
Code Completion improvements
Added support for the CREATE TABLE AS SELECT statement in Azure Synapse
User-reported and internal bug fixes
Fixed SSMS crash when generating quick info for typed objects like variables and functions (D134058, D130869)
Fixed the unnecessary addition of parentheses when inserting a synonym for a table from the dropdown list (D133432)
Fixed the Snippet Manager's behavior when changing the folder path for snippets (D131496)
Fixed a leak of open sessions that occurred when working with Azure SQL and Azure Synapse cloud servers (D128255)
Fixed an error that occurred when attempting to insert a snippet by pressing Tab (D127387)
Fixed the redundant enclosing of values in quotes when copying data in JSON format (D126998)
Improved the performance of hint generation when working with scripts containing a large number of aliases (D107724)
Fixed the Snippet Manager window display on high-DPI monitors (D130698, D133040)