Visual Query Editor 
In the Visual Query Editor, you can enter SQL statements graphically and edit them, as well as display foreign key dependencies between tables.
More information: Visual Query
Note
You can only use normal joins in the Visual Query Editor. Outer joins are not possible.
Command |
Description |
|---|---|
Load |
Open a saved SQL statement from a repository or file |
Save |
Save an SQL statement in a repository or file |
Save As ... |
Save an SQL statement under a different name |
Explain SQL |
Execute EXPLAIN statement for the SQL statement The system displays the result of the EXPLAIN statement in the Explain view. See: SQL Optimizer, Analyzing Search Strategies Using the EXPLAIN Statement |
Execute SQL |
The system executes the SQL statement.
|
Prepare Statement |
|
Choose Connection |
Select connection to database:
|
Clear |
Clear input field |
Format |
Format input |
Command |
Description |
|---|---|
Go to Row ... |
Go to row ... |
Export Cell to ... |
Export cell to ... |
Export Result ... |
Export result to a file |
Filters |
Define filters for columns |
Edit |
Edit a data record |
As AUTOCOMMIT mode, SQL mode, and isolation level, the system uses the values that you specified when you configured Database Studio. More information: Configuring Database Studio
To use other settings in the SQL editor that is currently open, change the setting on the Properties tab page (if this tab page is not open, choose 
Window 
Show View Properties
):
ON |
The database system performs all the necessary COMMIT actions automatically. |
OFF |
You have to enter COMMIT commands explicitly. |
Name |
Description |
|---|---|
INTERNAL |
SAP MaxDB SQL definition |
ORACLE |
ORACLE 7 SQL definition |
For more information about the isolation level: Concepts of the Database System, Isolation Level