Chapter 5: DDL statements

Table of Contents

ALTER DATABASE

BEGIN BACKUP

END BACKUP

ADD DIFFERENCE FILE

DROP DIFFERENCE FILE

ALTER DOMAIN

Rename domain

SET DEFAULT to any context variable

ALTER EXTERNAL FUNCTION

ALTER PROCEDURE

Default argument values

Restriction on altering used procedures

ALTER SEQUENCE

ALTER TABLE

ADD column: Context variables as defaults

ALTER COLUMN: DROP DEFAULT

ALTER COLUMN: SET DEFAULT

ALTER COLUMN: POSITION now 1-based

CHECK accepts NULL outcome

FOREIGN KEY without target column references PK

FOREIGN KEY creation no longer requires exclusive access

UNIQUE constraints now allow NULLs

USING INDEX subclause

ALTER TRIGGER

Multi-action triggers

Restriction on altering used triggers

PLAN allowed in trigger code

ALTER TRIGGER no longer increments table change count

COMMENT

CREATE DATABASE

16 Kb page size supported

DIFFERENCE FILE parameter

CREATE DOMAIN

Context variables as defaults

CREATE EXCEPTION

Message length increased

CREATE GENERATOR

CREATE SEQUENCE preferred

Maximum number of generators significantly raised

CREATE INDEX

UNIQUE indices now allow NULLs

Indexing on expressions

Maximum index key length increased

Maximum number of indices per table increased

CREATE PROCEDURE

CREATE SEQUENCE

CREATE TABLE

CHECK accepts NULL outcome

Context variables as column defaults

FOREIGN KEY without target column references PK

FOREIGN KEY creation no longer requires exclusive access

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

Full SELECT syntax supported

PLAN subclause disallowed in 1.5, reallowed in 2.0

Triggers on updatable views block auto-writethrough

View with non-participating NOT NULL columns in base table can be made insertable

CREATE OR ALTER EXCEPTION

CREATE OR ALTER PROCEDURE

CREATE OR ALTER TRIGGER

DECLARE EXTERNAL FUNCTION

BY DESCRIPTOR parameter passing

RETURNS PARAMETER n

DECLARE FILTER

DROP GENERATOR

DROP PROCEDURE

Restriction on dropping used procedures

DROP SEQUENCE

DROP TRIGGER

Restriction on dropping used triggers

DROP TRIGGER no longer increments table change count

RECREATE EXCEPTION

RECREATE PROCEDURE

Restriction on recreating used procedures

RECREATE TABLE

RECREATE TRIGGER

Restriction on recreating used triggers

RECREATE VIEW

REVOKE ADMIN OPTION

SET GENERATOR