FirebirdSQL logo

The Firebird 5.0 Language Reference

Firebird 5.0 Language Reference

About the Firebird 5.0 Language Reference
SQL Language Structure
Data Types and Subtypes
Integer Data Types

Integer Data Types

Floating-Point Data Types

Floating-Point Data Types

Fixed-Point Data Types

Fixed-Point Data Types

Data Types for Dates and Times

Data Types for Dates and Times

Character Data Types

Character Data Types

Boolean Data Type

Boolean Data Type

Binary Data Types

Binary Data Types

Array Types

Array Types

Special Data Types

Special Data Types

Conversion of Data Types

Conversion of Data Types

Custom Data Types — Domains

Custom Data Types — Domains

Data Type Declaration Syntax

Data Type Declaration Syntax

Common Language Elements
Expressions

Expressions

Predicates

Predicates

Data Definition (DDL) Statements

DATABASE
SHADOW
DOMAIN
TABLE
INDEX
VIEW
TRIGGER
PROCEDURE
FUNCTION
EXTERNAL FUNCTION
PACKAGE
PACKAGE BODY
FILTER
SEQUENCE
EXCEPTION
COLLATION
CHARACTER SET
Comments
Data Manipulation (DML) Statements
Procedural SQL (PSQL) Statements
Elements of PSQL

Elements of PSQL

Stored Procedures

Stored Procedures

Stored Functions

Stored Functions

PSQL Blocks

Packages

Packages

Triggers

Triggers

Writing the Body Code

Writing the Body Code

Trapping and Handling Errors

Trapping and Handling Errors

Built-in Scalar Functions
Context Functions

Context Functions

Mathematical Functions

Mathematical Functions

String and Binary Functions

String and Binary Functions

Date and Time Functions

Date and Time Functions

Type Casting Functions

Type Casting Functions

Bitwise Functions

Bitwise Functions

UUID Functions

UUID Functions

Functions for Sequences (Generators)

Functions for Sequences (Generators)

Conditional Functions

Conditional Functions

Special Functions for

Special Functions for

Cryptographic Functions

Cryptographic Functions

Other Functions

Other 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


ODBC

Firebird ODBC/JDBC Driver 2.0 Manual

ODBC/JDBC Driver for Firebird Client Applications
Installing the Driver
Firebird ODBC Configuration
Connecting to Firebird from Applications
Developing with the Firebird ODBC/JDBC Driver
Firebird Events
The Services Interface

Examples

Licence Notices

Document History


firebird-5-release-notes

Firebird 5.0 Release Candidate 2 Release Notes

General Notes
New In Firebird 5.0
Changes in the Firebird Engine
Changes to the Firebird API and ODS
Reserved Words and Changes
Configuration Additions and Changes
Security
Management Statements
Data Definition Language (DDL)
Data Manipulation Language (DML)
Procedural SQL (PSQL)
Monitoring Command-line Utilities
Compatibility Issues
Bugs Fixed

Firebird 5.0 Project Teams

Licence Notice