The SQL Editor is a custom editor provided for simplifying SQL maintenance. It can be invoked in two ways:
- from the Connections Pane,
- from the Statements view of a particular dataset or command.
Invoking SQL Editor for manual queries
Simply right-click any connection in the Connections Pane and select Open SQL Editor to open a new SQL Editor for the selected connection. You can also right-click a data table in the Data Tables Pane or a table or view in the Data Explorer to open a new SQL Editor that queries that table.
You can use this instance of the SQL Editor to run any query or command on the selected connection.
Invoking SQL Editor for a Statement
You can also invoke SQL Editor for a specific data table or command statement on the Statements page of the Data Table Details or Command Details views (Detail Pane). If you open SQL Editor like this, you will be editing the SQL associated with the statement in question and any changes you make to the SQL in the editor will be applied to the statement.
Using the SQL Editor
In SQL Editor, you can drag items from the Data Explorer to the SQL text window to create new SQL queries or to use field names in the current query:
The screenshot above shows how you can test a newly created and/or modified SQL by clicking on "Run as DataSet".
- Schema Modeler