Chapter 5: Data Definition (DDL) Statements

Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → Data Definition (DDL) Statements

Firebird

Chapter 5: Data Definition (DDL) Statements

Table of Contents

CREATE DATABASE
ALTER DATABASE
DROP DATABASE

CREATE SHADOW
DROP SHADOW

CREATE DOMAIN
ALTER DOMAIN
DROP DOMAIN

CREATE TABLE
ALTER TABLE
DROP TABLE
RECREATE TABLE

CREATE INDEX
ALTER INDEX
DROP INDEX
SET STATISTICS

CREATE VIEW
ALTER VIEW
CREATE OR ALTER VIEW
DROP VIEW
RECREATE VIEW

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

CREATE PROCEDURE
ALTER PROCEDURE
CREATE OR ALTER PROCEDURE
DROP PROCEDURE
RECREATE PROCEDURE

EXTERNAL FUNCTION

DECLARE EXTERNAL FUNCTION
ALTER EXTERNAL FUNCTION
DROP EXTERNAL FUNCTION

DECLARE FILTER
DROP FILTER

SEQUENCE (GENERATOR)

CREATE SEQUENCE
ALTER SEQUENCE
SET GENERATOR
DROP SEQUENCE

CREATE EXCEPTION
ALTER EXCEPTION
CREATE OR ALTER EXCEPTION
DROP EXCEPTION
RECREATE EXCEPTION

CREATE COLLATION
DROP COLLATION

CHARACTER SET

ALTER CHARACTER SET

CREATE ROLE
ALTER ROLE
DROP ROLE

COMMENT ON

DDL is the data definition language subset of Firebird's SQL language. DDL statements are used to create, modify and delete database objects that have been created by users. When a DDL statement is committed, the metadata for the object are created, changed or deleted.

Firebird 2.5 Language Reference → Firebird 2.5 Language Reference → Data Definition (DDL) Statements