Chapter 5: DDL statements

Table of Contents

ALTER DOMAIN

Rename domain

SET DEFAULT to any context variable

ALTER TABLE

ADD column: Context variables as defaults

ALTER COLUMN: POSITION now 1-based

FOREIGN KEY without target column references PK

UNIQUE constraints now allow NULLs

USING INDEX subclause

ALTER TRIGGER

Multi-action triggers

ALTER TRIGGER no longer increments table change count

PLAN allowed in trigger code

CREATE DATABASE

16 Kb page size supported

CREATE DOMAIN

Context variables as defaults

CREATE GENERATOR

Maximum number of generators significantly raised

CREATE INDEX

UNIQUE indices now allow NULLs

Maximum number of indices per table increased

CREATE TABLE

Context variables as column defaults

FOREIGN KEY without target column references PK

UNIQUE constraints now allow NULLs

USING INDEX subclause

CREATE TRIGGER

Multi-action triggers

CREATE TRIGGER no longer increments table change count

PLAN allowed in trigger code

CREATE VIEW

PLAN subclause disallowed

CREATE OR ALTER PROCEDURE

CREATE OR ALTER TRIGGER

DECLARE EXTERNAL FUNCTION

BY DESCRIPTOR parameter passing

RETURNS PARAMETER n

DROP GENERATOR

DROP TRIGGER

DROP TRIGGER no longer increments table change count

RECREATE PROCEDURE

RECREATE TABLE

RECREATE VIEW