Firebird 2.5 Language ReferenceFirebird 2.5 Language Reference → Data Definition (DDL) Statements
Firebird Firebird Prev: PredicatesFirebird 2.5 Language ReferenceUp: Firebird 2.5 Language ReferenceNext: DATABASE

Chapter 5: Data Definition (DDL) Statements

Table of Contents

DATABASE
CREATE DATABASE
ALTER DATABASE
DROP DATABASE
SHADOW
CREATE SHADOW
DROP SHADOW
DOMAIN
CREATE DOMAIN
ALTER DOMAIN
DROP DOMAIN
TABLE
CREATE TABLE
ALTER TABLE
DROP TABLE
RECREATE TABLE
INDEX
CREATE INDEX
ALTER INDEX
DROP INDEX
SET STATISTICS
VIEW
CREATE VIEW
ALTER VIEW
CREATE OR ALTER VIEW
DROP VIEW
RECREATE VIEW
TRIGGER
CREATE TRIGGER
ALTER TRIGGER
CREATE OR ALTER TRIGGER
DROP TRIGGER
RECREATE TRIGGER
PROCEDURE
CREATE PROCEDURE
ALTER PROCEDURE
CREATE OR ALTER PROCEDURE
DROP PROCEDURE
RECREATE PROCEDURE
EXTERNAL FUNCTION
DECLARE EXTERNAL FUNCTION
ALTER EXTERNAL FUNCTION
DROP EXTERNAL FUNCTION
FILTER
DECLARE FILTER
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
DROP COLLATION
CHARACTER SET
ALTER CHARACTER SET
ROLE
CREATE ROLE
ALTER ROLE
DROP ROLE
COMMENTS
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.

Prev: PredicatesFirebird 2.5 Language ReferenceUp: Firebird 2.5 Language ReferenceNext: DATABASE
Firebird 2.5 Language ReferenceFirebird 2.5 Language Reference → Data Definition (DDL) Statements