Background documentationSQL Statements: Overview Locate this document in the navigation structure

 

All SQL statements (sql_statement) can be embedded in programming languages and, with the exception of NEXT STAMP, can be specified interactively. Comments (sql_comment) can be specified for every SQL statement.

For many SQL statements, example statements have been formulated using the demo data for the SQL tutorial.

Significant changes to the syntax as compared with older database versions are described in the section Syntax Changes.

SQL Statements for Data Manipulation
SQL Statements for Data Queries
SQL statements for Statistics Management
SQL Statements for Statistics Management

UPDATE STATISTICS Statement

MONITOR Statement