SQL Statements: Overview

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 Definition

SQL Statements for Data Definition
CREATE TABLE Statement	DROP TABLE Statement	ALTER TABLE Statement RENAME TABLE Statement RENAME COLUMN Statement EXISTS TABLE Statement
CREATE SCHEMA Statement	DROP SCHEMA Statement	RENAME SCHEMA Statement
CREATE DOMAIN Statement	DROP DOMAIN Statement
CREATE SEQUENCE Statement	DROP SEQUENCE Statement
CREATE SYNONYM Statement	DROP SYNONYM Statement	RENAME SYNONYM Statement
CREATE VIEW Statement	DROP VIEW Statement	RENAME VIEW Statement
CREATE INDEX Statement	DROP INDEX Statement	ALTER INDEX Statement RENAME INDEX Statement
CREATE DBPROC[EDURE] Statement	DROP DBPROC[EDURE] Statement
CREATE SYSTEM TRIGGER Statement	DROP SYSTEM TRIGGER Statement
CREATE FUNCTION Statement	DROP FUNCTION Statement
CREATE TRIGGER Statement	DROP TRIGGER Statement
COMMENT ON Statement

SQL Statements for Authorization

SQL Statements for Authorization
CREATE USER Statement	DROP USER Statement	ALTER USER Statement RENAME USER Statement GRANT USER Statement
CREATE USERGROUP Statement	DROP USERGROUP Statement	ALTER USERGROUP Statement RENAME USERGROUP Statement GRANT USERGROUP Statement
ALTER PASSWORD Statement
CREATE ROLE Statement	DROP ROLE Statement
GRANT Statement	REVOKE Statement

SQL Statements for Data Manipulation

SQL Statements for Data Manipulation
INSERT Statement	UPDATE Statement	DELETE Statement
NEXT STAMP Statement	CALL Statement

SQL Statements for Data Queries

SQL Statements for Data Queries
QUERY Statement	SINGLE SELECT Statement	EXPLAIN Statement
FETCH Statement	CLOSE Statement

SQL Statements for Transaction Management

SQL Statements for Transaction Management
CONNECT Statement	SET Statement
COMMIT Statement	ROLLBACK Statement
SUBTRANS Statement	SQL SAVEPOINT Statements
INNER TRANSACTION Statement	LOCK Statement
UNLOCK Statement	RELEASE Statement

SQL statements for Statistics Management

SQL Statements for Statistics Management
UPDATE STATISTICS Statement	MONITOR Statement