Switch to: V9V8V7V6V5

SQL Editor - Left Side Panel Help

The Left Side Panel (or Navigator) of Valentina SQL Editor assists in writing queries. It allows you to access several different tabs including: Schema Tab, Queries Tab, Templates Tab and Snippets Tab. Click on each tab within the navigator to display the objects of the tab.

Schema Tab

The Schema tab-panel displays the schema tree of the current database to help you write SQL query more effectively.

You can filter the tree using the filter field located at the bottom of the tab.

Double Click Object

Double-click a Schema object in the Schema tab to add a reference into the SQL Editor at the current cursor position.

The addition to your code is appropriate to the type of Schema object.

Drag and Drop Database Objects

You can drag objects from the navigator into the main edit area. When objects are dropped into the edit area, Valentina Studio displays a dialog for editing options for the SQL command.

If you drag a Table into the main edit area, you will see:

Drag Container of Database Objects

You can drag entire folders with database objects, e.g. Tables or Fields. After dropping the objects, you get comma-separated list with names of all its elements:

For Tables:

"actor", "address", "category", "city", "country", "customer", "film", "film_actor", "film_category", "film_text", "inventory", "language", "payment", "rental", "staff", "store", "T1"

For fields:

"actor"."actor_id", "actor"."first_name", "actor"."last_name", "actor"."last_update"

Schema Tab Contextual Menu

Each object of the tree has the context menu:

In addition to standard object actions, it allows you to copy the object name, one of the standard generated queries to the clipboard or append it to the end of the query field.

Queries Tab

The Queries tab-panel shows all queries, saved or created in the Valentina Studio Query Editor.

Double-click a query to set its text within the SQL Editor.

Queries Tab Toolbar

The Queries Tab toolbar is located at the bottom of the tab:

  • “Add” button opens the Query Editor to create a new query;
  • “Delete” button deletes the selected query;
  • Filter field to filter queries by name.

Templates Tab

On the SQL Editor Templates Tab are predefined templates of SQL commands. Templates differ depending on the database engine used.

Double-click the template to add the text of the template to the SQL Editor.

Templates Tab Context Menu

You can copy to clipboard or send the template text to the editor.

Snippets Tab

The Snippets tab-panel lets you create, edit and save your own named code snippets.

Double-click the snippet to add it at the current position of the text cursor or drag snippet text to an arbitrary place.

Snippet Object Contextual Menu

You can copy to clipboard or send the snippet text to the editor.

Snippet Navigator Contextual Menu

Click in the empty space of the tab to view actions that can be performed over all created snippets.