Statements
One reference page for each statement, in alphabetical order.
Volume II: SQL Reference Manual
- ALLOCATE CURSOR: allocate a cursor for a query prepared
- ALLOCATE DESCRIPTOR: allocate an SQL descriptor area
- ALTER DATABASE: hand the database on to another owner, or change the replica group's members
- ALTER DOMAIN: change a domain's default or constraints
- ALTER EMBEDDING MODEL: change an embedding model's options
- ALTER EXTENSION: update an extension to another version
- ALTER INDEX: change an index's options
- ALTER PROPERTY GRAPH: add or drop a graph's element tables, labels and properties, or compile it
- ALTER SEQUENCE: change a sequence generator
- ALTER TABLE: change a base table
- ALTER TRANSFORM: add or drop the functions of a transform group
- ALTER TYPE: add or drop a structured type's attributes and methods
- ALTER USER: change a user's password, or whether it may create roles
- ALTER XQUERY MODULE: replace a registered XQuery module's text
- BACKUP DATABASE: take a backup of the database while it serves (extension)
- BEGIN: group statements with their own variables, conditions, cursors and handlers
- CALL: run an SQL-invoked procedure
- CANCEL CONNECTION: cancel what a connection of the server runs
- CASE: run the statements of the first WHEN that holds
- CLOSE: close a cursor
- COMMIT: end a transaction, keeping its changes
- CONNECT: connect to a server
- COPY DESCRIPTOR: copy a descriptor area, or an item's fields, to a PTF descriptor area (in a component procedure)
- CREATE ADJACENCY INDEX: index the edges of a property graph's edge table
- CREATE ASSERTION: define an assertion
- CREATE CAST: define a cast of a user-defined type by a function
- CREATE COLLATION: define a collation
- CREATE DOMAIN: define a domain
- CREATE EMBEDDING MODEL: define an embedding model of a plug-in
- CREATE EXTENSION: load an extension of an external plug-in
- CREATE FUNCTION: define an SQL-invoked function, or a polymorphic table function
- CREATE GRAPH: create a GQL graph, typed by a graph type or open
- CREATE GRAPH TYPE: define the node and edge types a typed GQL graph holds
- CREATE HYBRID VECTOR INDEX: define an index of a text and a vector column, for hybrid search
- CREATE INDEX: define an index
- CREATE LABEL INDEX: number the elements of a property graph's element tables for label tests
- CREATE METHOD: give a method of a user-defined type its body
- CREATE MODULE: define an SQL-server module
- CREATE ORDERING: say how values of a user-defined type compare
- CREATE PROCEDURE: define an SQL-invoked procedure
- CREATE PROPERTY GRAPH: define a property graph over tables
- CREATE REACHABILITY INDEX: keep which vertices a property graph's edge table leads to
- CREATE RESTORE POINT: name a point of the log a restore may stop at (extension)
- CREATE ROLE: define a role
- CREATE SCHEMA: define a schema
- CREATE SEQUENCE: define a sequence generator
- CREATE TABLE: define a base table
- CREATE TRANSFORM: define transform groups of a user-defined type
- CREATE TRIGGER: define a trigger
- CREATE TYPE: define a distinct or structured type
- CREATE USER: define a user
- CREATE VECTOR DISTANCE FUNCTION: define a metric of vectors in SQL
- CREATE VECTOR INDEX: define an approximate nearest-neighbour index
- CREATE VECTOR PIPELINE: keep a table of embedded chunks in step with a table of texts
- CREATE VIEW: define a viewed table
- CREATE XML SCHEMA: register an XML Schema
- CREATE XQUERY MODULE: register an XQuery library module
- DECLARE CURSOR: declare a cursor
- DECLARE HANDLER: say what runs when a condition is raised (in a compound statement)
- DEALLOCATE DESCRIPTOR: deallocate an SQL descriptor area
- DEALLOCATE PREPARE: forget a statement prepared
- DECLARE LOCAL TEMPORARY TABLE: declare a session's own temporary table
- DELETE: delete rows
- DESCRIBE: describe a statement prepared in an SQL descriptor area
- DISCONNECT: end connections
- DROP ASSERTION: drop an assertion
- DROP CAST: drop a user-defined cast
- DROP COLLATION: drop a collation
- DROP DOMAIN: drop a domain
- DROP EMBEDDING MODEL: drop an embedding model
- DROP EXTENSION: drop an extension
- DROP GRAPH: drop a GQL graph and its tables
- DROP GRAPH TYPE: drop a graph type
- DROP INDEX: drop an index
- DROP MODULE: drop an SQL-server module
- DROP ORDERING: drop a user-defined type's ordering
- DROP PROPERTY GRAPH: drop a property graph
- DROP ROLE: drop a role
- DROP ROUTINE: drop an SQL-invoked function, procedure or method
- DROP SCHEMA: drop a schema
- DROP SEQUENCE: drop a sequence generator
- DROP TABLE: drop a base table
- DROP TRANSFORM: drop transform groups of a user-defined type
- DROP TRIGGER: drop a trigger
- DROP TYPE: drop a distinct or structured type
- DROP USER: drop a user
- DROP VECTOR DISTANCE FUNCTION: drop a distance function
- DROP VECTOR PIPELINE: stop keeping a table of embedded chunks
- DROP VIEW: drop a view
- DROP XML SCHEMA: drop a registered XML Schema
- DROP XQUERY MODULE: drop a registered XQuery module
- END CONNECTION: end a connection of the server
- EXECUTE: run a statement prepared
- EXECUTE GQL: run a GQL request on a graph
- EXECUTE IMMEDIATE: prepare a statement and run it at once
- EXPLAIN: show how a query is planned
- FETCH: move a cursor and read its row
- FOR: run statements for each row of a query
- FREE LOCATOR: end large object locators before their transaction does
- GET DESCRIPTOR: read fields of an SQL descriptor area
- GET DIAGNOSTICS: read the diagnostics area
- GRANT: grant privileges, or roles
- HOLD LOCATOR: keep large object locators past the end of their transaction
- IF: run statements if a condition is true
- INSERT: insert rows
- ITERATE: begin the next iteration of a loop (in a labelled statement)
- LEAVE: end a labelled statement
- LOOP: run statements again and again until something leaves
- MERGE: update, delete and insert rows of a table from one source
- OPEN: open a cursor
- PIPE ROW: give a row of a polymorphic table function's result (in a component procedure)
- PREPARE: prepare a statement, by name
- RELEASE SAVEPOINT: destroy a savepoint, keeping the changes since
- REPEAT: run statements until a condition is true
- RESCAN BACKUP TARGET: find again the backups and archived segments a target holds (extension)
- RESIGNAL: raise again the condition a handler handles (in a handler)
- RETURN: give the value of an SQL-invoked function
- REVOKE: revoke privileges, or roles
- ROLLBACK: end a transaction, undoing its changes, or undo them back to a savepoint
- SAVEPOINT: mark a place in a transaction to roll back to
- SELECT: read rows
- SET: change a session setting
- SET (assignment): assign a value to an SQL variable or parameter (in a compound statement)
- SET CATALOG: set the default catalog
- SET CONNECTION: choose the current connection
- SET CONSTRAINTS: set constraint modes
- SET DATABASE: change a database setting
- SET DESCRIPTOR: set fields of an SQL descriptor area
- SET ROLE: set the session's current role
- SET COLLATION: set the session's collation
- SET SCHEMA: set the default schema
- SET SESSION AUTHORIZATION: set the session's authorization identifier
- SET TIME ZONE: set the session's time zone
- SET TRANSACTION: set the next transaction's modes
- SET TRANSFORM GROUP: choose the session's transform groups
- SIGNAL: raise a condition
- TRUNCATE TABLE: delete every row of a table at once
- UPDATE: update rows
- WHILE: run statements while a condition is true
Valid SQL not processed
These statements of SQL-92 are read in full, by their syntax, and then refused as valid SQL that turborel does not process: SQLCODE -900, SQLSTATE 0A000, the message naming what is not processed. A statement written against its syntax is a syntax error instead (SQLCODE -102).
| Statements | Why |
|---|---|
| CREATE CHARACTER SET, CREATE TRANSLATION, DROP CHARACTER SET, DROP TRANSLATION | One character set, SQL_TEXT, its one collation, and no translations: never others |
| SET NAMES | The same |
| CONNECT, SET CONNECTION, DISCONNECT, run by a session of an embedded database | They are the SQL-agent's, run by the client, not by a database (CONNECT) |
The standard: ISO/IEC 9075:1992 §11.28, §11.29, §11.32 and §11.33 (character sets and translations), §16.3 (SET NAMES) and §15.1–§15.3 (connections).