SQL Coding Assistance

Code Completion

Context-sensitive name suggestions

The application suggests object names for use at a certain position of the code.

SQL Code Completion

Object member lists

The application suggests object names for use at a certain position of the code.

Object member list

Column picker for quick list building

You can select required columns from the prompt list using only the mouse to add them to your SQL query document.

Column Picker for Quick List Building

JOIN clause auto generation

The application suggests a full JOIN clause based on foreign keys, or it can suggests conditions that are based on column names.

JOIN Clause Auto Generation

Wildcard expansion

You can replace the asterisk (*) character with the list of columns from the required table or view on pressing the Tab key.

Wildcart Expansion

Auto-generation of table aliases

Once you have entered an object name, the application automatically generates an alias for it in the FROM list of your SQL document.

Auto-generation of table aliases

Expansion of INSERT, EXEC, and ALTER statements

Once you have entered an object name, the application automatically generates an alias for it in the FROM list of a query.

INSERT, EXEC, and ALTER statements expansion

Keyword case adjustment when typing

The application recognizes what you are typing, and converts the keywords to uppercase letters, in case you are writing in lowercase.

Adjust Keyword Case on Typing

Context-sensitive keywords suggestion

The application analyzes the context in order to predict what you may type next, and displays only relative keywords and names of database objects.

Context-Sensitive Suggestion of Keywords

Database context detection

The application displays the list of database objects from the current database or schema.

Database Context Detectio

Smart filtering in the suggestion list

The application filters names of objects and keywords in the list automatically based on what you are typing, and suggests relative ones.

Database Context Detection

Semi-transparent suggestion box

You can hold the Ctrl key to make the suggestion box semi-transparent. The option helps to see the background code without closing the suggestion box.

Semi-transparent suggestion box

SQL code formatting

The application includes multiple ways for code formatting, including:

  • A wide set of code formatting options
  • Batch formatting of SQL files
  • Auto-formatting of code pasted from the clipboard
  • ...and much more
SQL code formatting

SQL snippets

With SQL snippets, you can:

  • Select a template from the drop-down list
  • Add new templates and edit existing ones by using snippet manager
  • Preview all the snippets using the code snippets window, and drag-and-drop required snippet directly to the SQL text editor
SQL snippets

Quick database object information

Quick object information

Hover the mouse cursor over a database object to see its details.

  • Select a template from the drop-down list
  • Add new templates and edit existing ones by using snippet manager
  • Preview all the snippets using the code snippets window, and drag-and-drop required snippet directly to the SQL text editor
Quick object information

Quick object information

Hover the mouse cursor over a database object to see its details.

SQL snippets

Parameter information for functions

The application also displays a hint with information about the function and its parameters when you call any built-in or user-defined function in a query.

Parameter information for functions

Code navigation

Document Outline window

The Document Outline window displays the logical structure of currently opened SQL document, and allows you to view and navigate statements in SQL documents.

Document Outline window

'Go to definition' for database objects

This option allows you to open Visual Object Editor and explore DDL objects with their properties.

Go to definition for database objects

Highlighting identifier occurrences

You can hover the screen cursor over an identifier to see all its occurrences in the text.

Highlight occurrences of an identifier

Phrase Completion

The application suggests not only separate keywords and object names, but entire code phrases. For instance, OUTER APPLY instead of APPLY, and ORDER BY instead of ORDER are prompted in the SELECT query. For a complete list of supported phrases, see product documentation.

Phrase Completion

Prompting clauses of MERGE statement

The prompt suggests clauses of the MERGE statement, that determine whether to update or insert into the target table or view.

Prompting clauses of MERGE statement