Generating 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 >

Generating SQL Statements

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.

dbquery_sql_generate

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.

mf_autocompletion

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