# Statements

This section provides manual pages for both high-level language constructs and parts thereof. For example, the CREATE INDEX statement is a high-level statement that you can execute directly via the JDBC interface. This section also includes clauses, which are not high-level statements and which you cannot execute directly but only as part of a high-level statement. The ORDER BY and WHERE clauses are examples of this kind of clause. Finally, this section also includes some syntactically complex portions of statements called expressions, for example SelectExpression and TableSubquery. These clauses and expressions receive their own manual pages for ease of reference.

Unless it is explicitly stated otherwise, you can execute or prepare and then execute all the high-level statements, which are all marked with the word statement, via the interfaces provided by JDBC. This manual indicates whether an expression can be executed as a high-level statement.

The sections provide general information about statement use, and descriptions of the specific statements.

- Interaction with the dependency system
- ALTER TABLE statement
- CREATE statements
- DROP Statements
- GRANT statement
  Use the GRANT statement to give permissions to a specific user or all users to perform actions on database objects.
- RENAME statements
- REVOKE statement
  Use the REVOKE statement to remove permissions from a specific user or from all users to perform actions on database objects.
- SET statements
- CALL (PROCEDURE)
- CONSTRAINT clause
- DECLARE GLOBAL TEMPORARY TABLE statement
  The DECLARE GLOBAL TEMPORARY TABLE statement defines a temporary table for the current connection.
- DELETE statement
- FOR UPDATE clause
- FROM clause
- GROUP BY clause
- HAVING clause
- INNER JOIN
- INSERT statement
- JOIN operation
- LEFT OUTER JOIN
- LOCK TABLE statement
- ORDER BY clause
- Query
- RIGHT OUTER JOIN
- ScalarSubquery
- SelectExpression
- SELECT statement
- TableExpression
- TableSubquery
- UPDATE statement
- VALUES expression
- WHERE clause
- WHERE CURRENT OF clause

Parent topic: SQL language reference
Related concepts
SQL identifiers
Built-in system functions
Built-in system procedures
Data types
Related reference
Capitalization and special characters
Built-in functions
SQL expressions