SQL statements can be generated automatically from the Database Browser, loaded from scripts, or entered manually.
To generate SQL SELECT statements from the Database Browser, do one of the following:
|•||Click a database object (such as a table or view), or a folder, in the Database Browser and drag it into the SQL Editor.|
|•||Right-click a database object in the Database Browser and select Show in SQL Editor | Select.|
To create SQL statements manually:
|1.||Start entering the SQL statement in the SQL Editor. If autocompletion is set to occur automatically, a drop-down list with suggestions appears while you enter statement.|
|2.||Use the cursor Up and Down keys to select a suggestion, and then press Enter to insert the highlighted option (see also SQL Auto-Completion Suggestions).|
© 2019 Altova GmbH