Reference Manual 

This document describes the syntax and semantics of SQL statements in the MaxDB database system.

An SQL statement carries out an operation on the database instance. SQL statements have been divided into groups according to the type of operation they perform as follows:

·        Data Definition

·        Authorization

·        Data Manipulation

·        Data Query

·        Transactions

·        Statistics

Overview Information

·        SQL Statements: Overview

·        Frequently Used Syntax Elements: Overview

·        Functions: Overview

·        Names: Overview

·        Privileges: Overview

·        Syntax List
The syntax notation used in this document is BNF.

·        System Tables

Examples of SQL Statements

The examples in the reference manual are based on the HOTEL database schema described in the SQL tutorial.

·        SQL Tutorial

·        Variables and Examples

Information About the Database System

·        Concepts of the Database System

·        Glossary

·        Technical Restrictions

·        Restrictions for SQL Statements

·        SQL Mode ORACLE