Show TOC

Background documentationVisual Query Editor Locate this document in the navigation structure

 

In the visual query editor, you can enter SQL statements graphically and edit them, as well as display foreign key dependencies between tables.

To open the visual query editor, choose   New   Visual SQL  in the context menu of Tables in the explorer tree.

More information: Visual Query

Note Note

You can only use normal joins in the Visual Query Editor. Outer joins are not possible.

End of the note.
SQL Editor: SQL Tab Page, Context Menu

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.

  • If you enter multiple SQL statements separated by comment characters, the system executes all the entered SQL statements.

  • If you selected an SQL statement in the SQL editor, the system executes only the selected SQL statement.

Prepare Statement

Testing Prepared Statements

Choose Connection

Select connection to database:

  • Landscape

  • Database computer

  • Database name

  • User name

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  ):

AUTOCOMMIT Mode

ON

The database system performs all the necessary COMMIT actions automatically.

OFF

You have to enter COMMIT commands explicitly.
SQL Modes

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

More Information

SQL Reference Manual

SQL Tutorial