Write SQL statements

Every SQL document contains the Text view with SQL editor in it. You switch to this view to edit your SQL queries.

When you type text in SQL editor, it automatically recognizes and highlights SQL syntax.

SQL editor

Besides, the editor provides SQL code completion and formatting functionality.

When you start typing a query in the SQL editor, it provides the most relevant suggestions for the given context and displays them in the form of the list. You can select and apply an appropriate suggestion.

Suggestions

When you hover the mouse over an identifier, you can see an object hint. It displays essential database object information, such as column names with data types for tables.

Object Information

For ease of SQL writing and reviewing, you can also use such supported shortcut keys as: CTRL+PLUS(+) KEY (to zoom the query in), CTRL+MINUS(-) KEY (to zoom the query out), CTRL+0 (to return an SQL document to the one-to-one scale).

You can write and execute SQL queries not only one at a time, but you may as well compose SQL scripts. SQL scripts consist of multiple SQL statements separated by an appropriate statement delimiter.