Firebird Documentation Index → Firebird 2.1 Language Ref. Update → DDL statements

Firebird Home

Chapter 5: DDL statements

Table of Contents

CREATE COLLATION
DROP COLLATION

CREATE DATABASE
ALTER DATABASE

CREATE DOMAIN
ALTER DOMAIN

CREATE EXCEPTION
CREATE OR ALTER EXCEPTION
RECREATE EXCEPTION

EXTERNAL FUNCTION

DECLARE EXTERNAL FUNCTION
ALTER EXTERNAL FUNCTION

DECLARE FILTER

CREATE INDEX

Privileges: GRANT and REVOKE

REVOKE ADMIN OPTION

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

CREATE TABLE
ALTER TABLE
RECREATE TABLE

CREATE TRIGGER
ALTER TRIGGER
CREATE OR ALTER TRIGGER
DROP TRIGGER
RECREATE TRIGGER

CREATE VIEW
RECREATE VIEW

Tip

Find a more recent version at Firebird 5.0 Language Reference: Data Definition (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.

Firebird Documentation Index → Firebird 2.1 Language Ref. Update → DDL statements