DbForge SQL Complete is a plugin developed for SQL Server Management Studio and Visual Studio, which can accelerate SQL code writing speed, provide context based intelligent advice, perform automatic formatting and refactoring, improve code readability, increase productivity, reduce costs, and more.

Users can save time and effort in the database and code development process with just a few clicks; This plugin provides user-defined table type recommendations, supports new CREATE COLUMNSTORE INDEX statement syntax, supports new keywords in CREATE TABLE statements, supports new keywords in CREATE INDEX statements, supports new keywords in CREATE PROCESS statements, supports member prompt input of user-defined table types, and can now refactor aliases.

Advanced automatic completion, beautiful SQL format, intelligent code refactoring

SQL Complete is an advanced solution for SQL database development, management, and management. This tool can be provided as an add-on for Visual Studio and SSMS, with excellent autocompletion functionality. Due to the functionality that SQL Complete includes but is missing from Management Studio and Visual Studio IntelliSense, it is easy to write, beautify, refactor SQL code, and significantly improve productivity.

• Accelerate the writing of SQL queries through IntelliSense style SQL code completion;
• Beautify T-SQL code and use intelligent SQL Formatter to unify code standards;
• Obtain basic information about database objects when writing code;
• Directly format SQL queries in SSMS or Visual Studio;
• Use a rich set of SQL code snippets to manage and modify existing code snippets or create your own templates;
• Easily browse SQL documents and synchronize them with code;
• Safely renaming tables, columns, procedures, and functions by automatically correcting references to renamed objects;
• Convenient tabs and windows, as well as intuitive management of SQL statements, greatly improve your productivity;

Main features

SQL code

Enhance the accuracy and quality of the code and simplify the process of creating SQL queries using the following features:

Function:

• Context based code completion
• CTE code completion
• Alias Management
• Object suggestions
• code refactoring
• SQL Fragment
• Statement Suggestions
• Code Highlight
• Automatic completion of table names

The add-in will be responsible for automatically completing SQL queries so that you can focus on the actual way the code works.

T-SQL refactoring

This feature allows you to improve the readability of your code by assigning meaningful and easily interpretable names to tables, columns, temporary tables and columns, views, stored procedures, and functions. SQL Complete will automatically correct all references to renamed objects.

Function:

• rename objects
• Renaming a variable
• Find invalid objects

You can also change the names of local and SQLCMD variables within a few seconds. The preview code is changed in the convenient tree view of the 'Rename' dialog window. By using the SQL Complete tool, SQL code refactoring becomes simple and seamless.

productivity

Using a rich feature set to improve work efficiency in creating, refactoring, modifying, and beautifying code:

Function:

• Data Grid Command
• Grid aggregation
• Jump between queries
• Label coloring
• Jumping between COLUMNS and VALUES in an Insert statement
• Execution warning
• Execution notification
• Easy to navigate, instant access to database object definitions, and other advanced options greatly facilitate the design and formatting of SQL statements.

SQL code format

Create new format configuration files or customize existing format configuration files to meet your needs. Fine tune your formatting style to easily improve code readability and introduce unified code formatting standards within the company.

Function:

• Format Configuration File
• Format setting
• Format files and directories
• Disable formatting of some code
• Batch Format
• Using SQL script formatting programs, you can use new or existing code. Try online SQL Formatter without downloading or installing any content!
• SQL Complete killer feature missing from SSMS since v18.

Why choose SQL Complete over SSMS IntelliSense?

Simple work

SQL Complete aims to improve productivity. With our tools, developers and DBAs who use SQL become faster because it can provide intelligent prompts based on code context, selected databases, etc. This application uses minimal prompts to guess what you want to write.

Standard encoding

Have you encountered any problems when developers in your team invented their own SQL coding standards? With SQL Complete, you can customize code style settings, share them with others using the Import and Export Settings wizard, and even start over by resetting custom settings to default values.

Clean up code using SQL format

SQL Complete provides you with an excellent opportunity to solve difficult to understand and malformed SQL code. Apply various formatting options to format the code according to your needs and preferences. Using SQL Complete makes your code easier to read, debug, and test.

Supports all SQL Server versions

Using standard tools, you will not be able to obtain SQL Server Management Studio IntelliSense for all versions of Microsoft SQL Server. SQL Complete supports all of these! Just install your server and our application - you can create miracles in your SQL coding!

Why is SQL Complete worth trying?

You can compete with competitors in every dimension of value, but you need to stand out in at least one aspect to win the favor of potential customers. This is the dimension of value provided by SQL Complete.

• By using advanced IntelliSense style SQL code to complete functionality, it is easy to develop pure and error free SQL code.
• When typing code using 9 predefined styles, you can use over 1500 options to flexibly format the code.
• Eliminate errors by debugging T-SQL code in SQL Server Management Studio directly from SQL documents.
• Using a rich set of default SQL code snippets, it is easy to modify or create custom code templates.
• Improve the readability of SQL code by quickly and correctly refactoring T-SQL in the document.
• With the help of tab coloring, definition, document session recovery, and many other convenient functions, productivity improvements can be observed.