Table of Contents

DATABASE

CREATE DATABASE

Using a Database Alias

Creating a Database Remotely

Optional Parameters for CREATE DATABASE

Examples Using CREATE DATABASE

ALTER DATABASE

Parameters for ALTER DATABASE

DROP DATABASE

SHADOW

CREATE SHADOW

AUTO | MANUAL Modes

Options for CREATE SHADOW

DROP SHADOW

DOMAIN

CREATE DOMAIN

Type-specific Details

CREATE DOMAIN Examples

ALTER DOMAIN

What ALTER DOMAIN Cannot Alter

ALTER DOMAIN Examples

DROP DOMAIN

TABLE

CREATE TABLE

Making a Column Non-nullable

Character Columns

Setting a DEFAULT Value

Domain-based Columns

Calculated Fields

Defining an ARRAY Column

Constraints

Global Temporary Tables (GTT)

External Tables

CREATE TABLE Examples

ALTER TABLE

Version Count Increments

The ADD Clause

The DROP Clause

The DROP CONSTRAINT Clause

The ALTER [COLUMN] Clause

Renaming a Column: the TO Keyword

Changing the Data Type of a Column: the TYPE Keyword

Changing the Position of a Column: the POSITION Keyword

The DROP DEFAULT and SET DEFAULT Clauses

The COMPUTED [BY] or GENERATED ALWAYS AS Clauses

Attributes that Cannot Be Altered

Examples Using ALTER TABLE

DROP TABLE

RECREATE TABLE

INDEX

CREATE INDEX

Unique Indexes

Index Direction

Computed (Expression) Indexes

Limits on Indexes

Examples Using CREATE INDEX

ALTER INDEX

Use of ALTER INDEX on a Constraint Index

DROP INDEX

SET STATISTICS

Index Selectivity

VIEW

CREATE VIEW

Updatable Views

WITH CHECK OPTION

Ownership of a View

ALTER VIEW

CREATE OR ALTER VIEW

DROP VIEW

RECREATE VIEW

TRIGGER

CREATE TRIGGER

Statement Terminators

Relation Triggers (on Tables or Views)

Database Triggers

ALTER TRIGGER

Permitted Changes to Triggers

CREATE OR ALTER TRIGGER

DROP TRIGGER

RECREATE TRIGGER

PROCEDURE

CREATE PROCEDURE

Statement Terminators

Parameters

Variable and Cursor Declarations

ALTER PROCEDURE

CREATE OR ALTER PROCEDURE

DROP PROCEDURE

RECREATE PROCEDURE

EXTERNAL FUNCTION

DECLARE EXTERNAL FUNCTION

DECLARE EXTERNAL FUNCTION Input Parameters

ALTER EXTERNAL FUNCTION

DROP EXTERNAL FUNCTION

FILTER

DECLARE FILTER

Specifying the Subtypes

Parameters

DROP FILTER

SEQUENCE (GENERATOR)

CREATE SEQUENCE

ALTER SEQUENCE

SET GENERATOR

DROP SEQUENCE

EXCEPTION

CREATE EXCEPTION

ALTER EXCEPTION

CREATE OR ALTER EXCEPTION

DROP EXCEPTION

RECREATE EXCEPTION

COLLATION

CREATE COLLATION

How the Engine Detects the Collation

Specific Attributes

DROP COLLATION

CHARACTER SET

ALTER CHARACTER SET

ROLE

CREATE ROLE

ALTER ROLE

DROP ROLE

COMMENTS

COMMENT ON