Executing SQL statements

Prerequisites

You are logged on to a database instance.

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.

CREATE SCHEMA hotel
//
SET CURRENT_SCHEMA = hotel

       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.

See also:

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.