SQL 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

Date query

Transactions

Statistics

Overview Information

SQL Statements: Overview

Frequently Used Syntax Elements: Overview

Functions: Overview

Names: Overview

Privileges: Overview

Syntax List

System Tables

Examples of SQL Statements

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

SQL Tutorial

Information about the Database System

Concepts of the Database System

Glossary

Technical Restrictions

Restrictions for SQL Statements

SQL Mode ORACLE