Statements that are Extensions to the ANSI/ISO Standard

  • ALLOCATE COLLECTION
  • ALLOCATE ROW
  • ALTER ACCESS_METHOD
  • ALTER FRAGMENT
  • ALTER FUNCTION
  • ALTER INDEX
  • ALTER PROCEDURE
  • ALTER ROUTINE
  • ALTER SECURITY LABEL COMPONENT
  • ALTER SEQUENCE
  • ALTER TRUSTED CONTEXT
  • ALTER USER
  • BEGIN WORK
  • CLOSE DATABASE
  • CREATE ACCESS_METHOD
  • CREATE AGGREGATE
  • CREATE CAST
  • CREATE DATABASE
  • CREATE DEFAULT USER
  • CREATE DISTINCT TYPE
  • CREATE EXTERNAL TABLE
  • CREATE FUNCTION
  • CREATE FUNCTION FROM
  • CREATE INDEX
  • CREATE OPAQUE TYPE
  • CREATE OPCLASS
  • CREATE PROCEDURE
  • CREATE PROCEDURE FROM
  • CREATE ROLE
  • CREATE ROUTINE FROM
  • CREATE ROW TYPE
  • CREATE SECURITY LABEL
  • CREATE SECURITY LABEL COMPONENT
  • CREATE SECURITY POLICY
  • CREATE SEQUENCE
  • CREATE SYNONYM
  • CREATE TRIGGER
  • CREATE TRUSTED CONTEXT
  • CREATE USER
  • CREATE XADATASOURCE
  • CREATE XADATASOURCE TYPE
  • DATABASE
  • DEALLOCATE COLLECTION
  • DEALLOCATE ROW
  • DROP ACCESS_METHOD
  • DROP AGGREGATE
  • DROP CAST
  • DROP DATABASE
  • DROP FUNCTION
  • DROP INDEX
  • DROP OPCLASS
  • DROP PROCEDURE
  • DROP ROLE
  • DROP ROUTINE
  • DROP ROW TYPE
  • DROP SECURITY LABEL
  • DROP SECURITY LABEL COMPONENT
  • DROP SECURITY POLICY
  • DROP SEQUENCE
  • DROP SYNONYM
  • DROP TABLE
  • DROP TRIGGER
  • DROP TRUSTED CONTEXT
  • DROP TYPE
  • DROP USER
  • DROP VIEW
  • DROP XADATASOURCE
  • DROP XADATASOURCE TYPE
  • EXECUTE FUNCTION
  • EXECUTE PROCEDURE
  • FLUSH
  • FREE
  • GRANT FRAGMENT
  • LOAD
  • LOCK TABLE
  • OUTPUT
  • PUT
  • RELEASE SAVEPOINT
  • RENAME COLUMN
  • RENAME DATABASE
  • RENAME INDEX
  • RENAME SECURITY LABEL
  • RENAME SECURITY LABEL COMPONENT
  • RENAME SECURITY POLICY
  • RENAME SEQUENCE
  • RENAME TABLE
  • RENAME TRUSTED CONTEXT
  • RENAME USER
  • REVOKE FRAGMENT
  • SAVE EXTERNAL DIRECTIVES
  • SET AUTOFREE
  • SET COLLATION
  • SET CONSTRAINTS (See SET Database Object Mode statement.)
  • SET Database Object Mode
  • SET DATASKIP
  • SET DEBUG FILE TO
  • SET DEFERRED_PREPARE
  • SET ENCRYPTION PASSWORD
  • SET ENVIRONMENT
  • SET EXPLAIN
  • SET INDEXES (See SET Database Object Mode statement.)
  • SET ISOLATION
  • SET LOCK MODE
  • SET LOG
  • SET OPTIMIZATION
  • SET PDQPRIORITY
  • SET ROLE
  • SET STATEMENT CACHE
  • SET TRIGGERS (See SET Database Object Mode statement.)
  • SET USER PASSWORD
  • START VIOLATIONS TABLE
  • STOP VIOLATIONS TABLE
  • TRUNCATE
  • UNLOAD
  • UNLOCK TABLE
  • UPDATE STATISTICS