Creating and Editing SQL Statements

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce > Browsing and Querying Databases >

Creating and Editing SQL Statements

The SQL Editor is used to write and execute SQL statements. It displays any SQL statements that you may have generated automatically, loaded from existing SQL scripts, or written manually. The SQL Editor supports autocompletion (see Auto-Completion), regions, and line or block comments.

dbquery_sql_editor

The SQL Editor toolbar provides the following buttons:

 

ic-db-togg-b

Toggle Browser: Toggles the Browser pane on and off.

ic-db-togg-r

Toggle Result: Toggles the Result pane on and off.

ic_execute-sql

Execute (F5): Clicking this button executes the SQL statements that are currently selected. If multiple statements exist and none are selected, then all are executed.

ic-undo

Undo: Allows you to undo an unlimited number of edits in the SQL window.

ic-redo2

Redo: Allows you to redo previously undone commands. You can step backward and forward through the undo history using both these commands.

ic-sql-import

Import SQL file: Opens an SQL file in the SQL Editor, which can then be executed.

ic-sql-export

Export SQL file: Saves SQL queries for later use.

ic-sql-openinDBS

Open SQL script in DatabaseSpy: Starts DatabaseSpy and opens the script in the SQL Editor.

ic-sql-options

Options: Opens the Options dialog box allowing you to define general database query settings as well as SQL Editor settings.


© 2019 Altova GmbH