Statement List

Go Up to SQL Statement and Function Reference

This chapter describes the following SQL statements:

A
ALTER DATABASE	ALTER DOMAIN	ALTER EXCEPTION
ALTER INDEX	ALTER PROCEDURE	ALTER TABLE
ALTER TRIGGER	ALTER USER
B
BASED ON	BEGIN DECLARE SECTION
C
CASE	CLOSE	CLOSE (BLOB)
COALESCE( )	COMMIT	CONNECT
CREATE DATABASE	CREATE DOMAIN	CREATE ENCRYPTION
CREATE EXCEPTION	CREATE GENERATOR	CREATE INDEX
CREATE JOURNAL	CREATE JOURNAL ARCHIVE	CREATE PROCEDURE
CREATE ROLE	CREATE SHADOW	CREATE SUBSCRIPTION
CREATE TABLE	CREATE TRIGGER	CREATE USER
CREATE VIEW
D
DECLARE CURSOR	DECLARE CURSOR (BLOB)	DECLARE EXTERNAL FUNCTION
DECLARE FILTER	DECLARE STATEMENT	DECLARE TABLE
DELETE	DESCRIBE	DISCONNECT
DROP DATABASE	DROP DOMAIN	DROP ENCRYPTION
DROP EXCEPTION	DROP EXTERNAL FUNCTION	DROP FILTER
DROP GENERATOR	DROP INDEX	DROP JOURNAL
DROP JOURNAL ARCHIVE	DROP PROCEDURE	DROP ROLE
DROP SUBSCRIPTION*	DROP SHADOW	DROP TRIGGER
DROP VIEW	DROP USER
E
END DECLARE SECTION	EVENT INIT	EVENT WAIT
EXECUTE	EXECUTE IMMEDIATE	EXECUTE PROCEDURE
F
FETCH	FETCH (BLOB)
G
GRANT	GRANT SUBSCRIBE	GRANT TEMPORARY SUBSCRIBE
I
INSERT	INSERT CURSOR (BLOB)
N
NULLIF( )
O
OPEN	OPEN (BLOB)
P
PREPARE
R
RELEASE SAVEPOINT	REVOKE	ROLLBACK
S
SAVEPOINT	SELECT	SET DATABASE
SET GENERATOR	SET NAMES (Reference)	SET SQL DIALECT
SET STATISTICS	SET SUBSCRIPTION	SET TRANSACTION
SHOW SQL DIALECT
T
TRUNCATE TABLE
U
UPDATE
W
WHENEVER

* For more information about creating subscriptions, see the Change View chapter in the Data Definition Guide.

Advance To:

• Function List (Language Reference Guide)