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

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

FILTER

General-purpose Aggregate Functions

AVG()

AVG

COUNT()

COUNT

LIST()

LIST

MAX()

MAX

MIN()

MIN

SUM()

SUM

Statistical Aggregate Functions

CORR()

CORR

COVAR_POP()

COVAR_POP

COVAR_SAMP()

COVAR_SAMP

STDDEV_POP()

STDDEV_POP

STDDEV_SAMP()

STDDEV_SAMP

VAR_POP()

VAR_POP

VAR_SAMP()

VAR_SAMP

Linear Regression Aggregate Functions

REGR_AVGX()

REGR_AVGY()

REGR_COUNT()

REGR_INTERCEPT()

REGR_INTERCEPT

REGR_R2()

REGR_SLOPE()

REGR_SXX()

REGR_SXY()

REGR_SYY()

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