Procedure documentationExecuting SQL statements Locate this document in the navigation structure

Prerequisites

You are logged on to a database.

Procedure

  1. Enter one or more SQL statements in the field SQL Entry.

    To separate two successive SQL statements from one another, enter a commented-out separator line. You can use // or -- at the beginning of the line as comment characters.

    Example Example

    CREATE SCHEMA hotel // SET CURRENT_SCHEMA = hotel

    End of the example.
  2. Choose Execute.

Result

If the SQL statement returns a result table, this is displayed in the result window. If it does not return a result table, a message is displayed in the result window.

If you executed multiple SQL statements simultaneously, you can switch back and forth between the result tables using the dropdown menu.

More Information

Saving SQL Statements

Screen Areas in Web SQL Studio

The SQL Tutorial provides a brief introduction to SQL. The SQL Reference Manual contains a more detailed description of the MaxDB SQL syntax.