Firebird 5.0 Language Reference

About The Firebird 5.0 Language Reference

Sql Language Structure

Data Types And Subtypes

Common Language Elements

Data Definition (Ddl) Statements

Database

Shadow

Domain

Table

Index

View

TRIGGER

CREATE TRIGGER

Statement Terminators

SQL Security

The Trigger Body

DML Triggers (on Tables or Views)

Who Can Create a DML Trigger?

Forms of Declaration

Phase

Row Events

Firing Order of Triggers

Examples of

Database Triggers

Who Can Create a Database Trigger?

Execution of Database Triggers and Exception Handling

Traps

Suppressing Database Triggers

Two-phase Commit

Some Caveats

Suppressing Database Triggers

Two-phase Commit

Some Caveats

Two-phase Commit

Some Caveats

Some Caveats

Examples of

DDL Triggers

Who Can Create a DDL Trigger?

Suppressing DDL Triggers

Examples of DDL Triggers

ALTER TRIGGER

Permitted Changes to Triggers

Who Can Alter a Trigger?

Examples using ALTER TRIGGER

CREATE OR ALTER TRIGGER

Example of

DROP TRIGGER

Who Can Drop a Trigger?

Example of

RECREATE TRIGGER

Example of

Procedure

Function

External Function

Package

Package Body

Filter

Sequence

Exception

Collation

Character Set

Comments

Data Manipulation (Dml) Statements

Procedural Sql (Psql) Statements

Built-In Scalar Functions

Aggregate Functions

Window (Analytical) Functions

System Packages

Context Variables

Transaction Control

Security

User Authentication

Sql Statements For User Management

Sql Privileges

Role

Statements For Granting Privileges

Statements For Revoking Privileges

Mapping Of Users To Objects

Database Encryption

Sql Security

Management Statements

Supplementary Information

Exception Codes And Messages

Reserved Words And Keywords

System Tables

Monitoring Tables

Security Tables

Plugin Tables

Character Sets And Collations

License Notice

Document History