dbForge SQL Complete Express

Note: The Express Edition will be activated after the expiration of the Standard Edition trial.

dbForge SQL Complete Express is a practical and effective add-in that seamlessly integrates within SQL Server Management Studio and Microsoft Visual Studio, providing developers with the right tools in order to increase efficiency.

Considering that developers and database administrators work with SQL scripts very much, thanks to features such as code completion, SQL formatter, code navigation and statement expansion, they will become more productive.

Before using dbForge SQL Complete Express, you need to make sure that one of the application the extension integrates with, works properly on your computer, since it is able to automatically recognize them when the installation process starts. After that, you are able to view that a new ‘SQL Complete’ menu is available in the main bar.

When you open a new query file, you will notice that dbForge SQL Complete Express is able to predict not only keywords and object names, but also code fragments and tables so you can simplify your work. For instance, in case you want to write a new SELECT, CREATE or INSERT statement, the extension will help you by automatically providing suggestions with basic scripts.

Also, you are able to view essential information about database objects while you are writing code. Simply point the mouse on the preferred table and view what attributes each column contains. This way, in case you want to order or group the information by specific variables, you are able to view which ones are available in the selected table.

Another important function is the ‘Code Navigation’ option, which becomes available from the right-click menu, that helps you to quickly locate the needed objects in the ‘Object Explorer’ panel.

Considering all of the above, dbForge SQL Complete Express proves to be a reliable and useful solution that comes in handy for developers and DBAs who need to set a wide range of formatting options and maintain SQL scripts in an easy manner.