DDL Statements

The statements in this chapter are grouped by the type of database object they operate on. For instance, ALTER DATABASE, CREATE DATABASE and DROP DATABASE are all found under DATABASE; DECLARE EXTERNAL FUNCTION and ALTER EXTERNAL FUNCTION are under EXTERNAL FUNCTION; etc.

GRANT and REVOKE, which can operate on a variety of object types, are together under Privileges.

• COLLATION
  • CREATE COLLATION
  • drop-collation
• COMMENT
• DATABASE
  • create-database
  • ALTER DATABASE
• DOMAIN
  • CREATE DOMAIN
  • ALTER DOMAIN
• EXCEPTION
  • CREATE EXCEPTION
  • CREATE OR ALTER EXCEPTION
  • RECREATE EXCEPTION
• EXTERNAL FUNCTION
  • DECLARE EXTERNAL FUNCTION
  • ALTER EXTERNAL FUNCTION
• FILTER
  • DECLARE FILTER
• INDEX
  • create-index
• PRIVILEGES: GRANT AND REVOKE
  • Privileges: GRANT and REVOKE, REVOKE ADMIN OPTION
• PROCEDURE
  • CREATE PROCEDURE
  • ALTER PROCEDURE
  • CREATE OR ALTER PROCEDURE
  • DROP PROCEDURE
  • RECREATE PROCEDURE
• SEQUENCE OR GENERATOR
  • CREATE SEQUENCE
  • CREATE GENERATOR
  • ALTER SEQUENCE
  • SET GENERATOR
  • DROP SEQUENCE
  • DROP GENERATOR
• TABLE
  • CREATE TABLE
  • ALTER TABLE
  • RECREATE TABLE
• TRIGGER
  • CREATE TRIGGER
  • ALTER TRIGGER
  • CREATE OR ALTER TRIGGER
  • DROP TRIGGER
  • RECREATE TRIGGER
• VIEW
  • CREATE VIEW
  • RECREATE VIEW