In the SQL Editor, you can enter, execute, and save SQL statements.
More information: Entering and Executing SQL Statements
The following rules apply:
You can write SQL syntax elements in either upper or lower case.
You can add any number of spaces and line breaks.
To force the system to take the case into account for database object identifiers (such as table names) and values in the form of literals, enter the identifier between single quotation marks: '<identifier>'.
To comment out a row, use // or -- at the start of the row.
To separate several SQL statements from one another, enter a commented-out separator line.
If you press the key combination CTRL+ Space after a word in the SQL editor, a list is displayed containing default values for this word. You must have already defined a corresponding template for this word. More information: Configuring Database Studio, Templates section.
Command |
Description |
---|---|
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, Displaying the Search Strategies Used by SQL Statements (EXPLAIN) |
Execute SQL |
The system executes the SQL statement.
|
Prepare Statement |
|
Choose Connection |
Select connection to database:
|
In the status window, the system displays messages regarding SQL statement execution.
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 ):
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, see Concepts of the Database System, Isolation Level.