SQL snippets

Preview all the snippets using the code snippets window, and drag-and-drop required
snippet directly to the SQL text editor

Quick database object information

Quick object information

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

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.

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.

"Go to definition" for database objects

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

Highlight occurrences of an identifier

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

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.

Clauses prompt of the MERGE statement

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

Founded in 1997, Devart is now one of the leading developers of database tools, management software, ALM solutions, and data providers for various database servers.