Firebird 2.5 Language Reference
Revision History
| 1.15 | 8 November 2023 |
Table of Contents
- Chapter 1. About the Firebird SQL Language Reference: for Firebird 2.5
- Chapter 2. SQL Language Structure
- Chapter 3. Data Types and Subtypes
- 3.1 Integer Data Types
- 3.2 Floating-Point Data Types
- 3.3 Fixed-Point Data Types
- 3.4 Data Types for Dates and Times
- 3.5 Character Data Types
- 3.6 Binary Data Types
- 3.7 Special Data Types
- 3.8 Conversion of Data Types
- 3.9 Custom Data Types — Domains
- Chapter 4. Common Language Elements
- 4.1 Expressions
- 4.2 Predicates
- Chapter 5. Data Definition (DDL) Statements
- 5.1
DATABASE - 5.2
SHADOW - 5.3
DOMAIN - 5.4
TABLE- 5.4.1
CREATE TABLE - 5.4.2
ALTER TABLE- 5.4.2.1 Version Count Increments
- 5.4.2.2 The
ADDClause - 5.4.2.3 The
DROPClause - 5.4.2.4 The
DROP CONSTRAINTClause - 5.4.2.5 The
ALTER [COLUMN]Clause - 5.4.2.6 Renaming a Column: the
TOKeyword - 5.4.2.7 Changing the Data Type of a Column: the
TYPEKeyword - 5.4.2.8 Changing the Position of a Column: the
POSITIONKeyword - 5.4.2.9 The
DROP DEFAULTandSET DEFAULTClauses - 5.4.2.10 The
COMPUTED [BY]orGENERATED ALWAYS ASClauses - 5.4.2.11 Attributes that Cannot Be Altered
- 5.4.2.12 Examples Using
ALTER TABLE
- 5.4.3
DROP TABLE - 5.4.4
RECREATE TABLE
- 5.4.1
- 5.5
INDEX - 5.6
VIEW - 5.7
TRIGGER - 5.8
PROCEDURE - 5.9
EXTERNAL FUNCTION - 5.10
FILTER - 5.11
SEQUENCE(GENERATOR) - 5.12
EXCEPTION - 5.13
COLLATION - 5.14
CHARACTER SET - 5.15
ROLE - 5.16
COMMENTS
- 5.1
- Chapter 6. Data Manipulation (DML) Statements
- 6.1
SELECT - 6.2
INSERT - 6.3
UPDATE - 6.4
UPDATE OR INSERT - 6.5
DELETE - 6.6
MERGE - 6.7
EXECUTE PROCEDURE - 6.8
EXECUTE BLOCK
- 6.1
- Chapter 7. Procedural SQL (PSQL) Statements
- 7.1 Elements of PSQL
- 7.2 Stored Procedures
- 7.3 Stored Functions
- 7.4 PSQL Blocks
- 7.5 Triggers
- 7.6 Writing the Body Code
- 7.6.1 Assignment Statements
- 7.6.2
DECLARE CURSOR - 7.6.3
DECLARE VARIABLE - 7.6.4
BEGIN … END - 7.6.5
IF … THEN … ELSE - 7.6.6
WHILE … DO - 7.6.7
LEAVE - 7.6.8
EXIT - 7.6.9
SUSPEND - 7.6.10
EXECUTE STATEMENT - 7.6.11
FOR SELECT - 7.6.12
FOR EXECUTE STATEMENT - 7.6.13
OPEN - 7.6.14
FETCH - 7.6.15
CLOSE - 7.6.16
IN AUTONOMOUS TRANSACTION - 7.6.17
POST_EVENT
- 7.7 Trapping and Handling Errors
- Chapter 8. Built-in Functions
- 8.1 Context Functions
- 8.2 Mathematical Functions
- 8.2.1
ABS() - 8.2.2
ACOS() - 8.2.3
ASIN() - 8.2.4
ATAN() - 8.2.5
ATAN2() - 8.2.6
CEIL(),CEILING() - 8.2.7
COS() - 8.2.8
COSH() - 8.2.9
COT() - 8.2.10
EXP() - 8.2.11
FLOOR() - 8.2.12
LN() - 8.2.13
LOG() - 8.2.14
LOG10() - 8.2.15
MOD() - 8.2.16
PI() - 8.2.17
POWER() - 8.2.18
RAND() - 8.2.19
ROUND() - 8.2.20
SIGN() - 8.2.21
SIN() - 8.2.22
SINH() - 8.2.23
SQRT() - 8.2.24
TAN() - 8.2.25
TANH() - 8.2.26
TRUNC()
- 8.2.1
- 8.3 String Functions
- 8.4 Date and Time Functions
- 8.5 Type Casting Functions
- 8.6 Bitwise Functions
- 8.7 UUID Functions
- 8.8 Functions for Sequences (Generators)
- 8.9 Conditional Functions
- 8.10 Aggregate Functions
- Chapter 9. Context Variables
- Chapter 10. Transaction Control
- 10.1 Transaction Statements
- 10.1.1
SET TRANSACTION - 10.1.2
COMMIT - 10.1.3
ROLLBACK - 10.1.4
SAVEPOINT - 10.1.5
RELEASE SAVEPOINT - 10.1.6 Internal Savepoints
- 10.1.7 Savepoints and PSQL
- 10.1.1
- 10.1 Transaction Statements
- Chapter 11. Security
- 11.1 User Authentication
- 11.2 SQL Privileges
- 11.2.1 The Object Owner
- 11.2.2 Statements for Granting Privileges
- 11.2.3 Statements for Revoking Privileges
- Appendix A. Supplementary Information
- Appendix B. Exception Codes and Messages
- Appendix C. Reserved Words and Keywords
- Appendix D. System Tables
- D.1
RDB$BACKUP_HISTORY - D.2
RDB$CHARACTER_SETS - D.3
RDB$CHECK_CONSTRAINTS - D.4
RDB$COLLATIONS - D.5
RDB$DATABASE - D.6
RDB$DEPENDENCIES - D.7
RDB$EXCEPTIONS - D.8
RDB$FIELDS - D.9
RDB$FIELD_DIMENSIONS - D.10
RDB$FILES - D.11
RDB$FILTERS - D.12
RDB$FORMATS - D.13
RDB$FUNCTIONS - D.14
RDB$FUNCTION_ARGUMENTS - D.15
RDB$GENERATORS - D.16
RDB$INDICES - D.17
RDB$INDEX_SEGMENTS - D.18
RDB$LOG_FILES - D.19
RDB$PAGES - D.20
RDB$PROCEDURES - D.21
RDB$PROCEDURE_PARAMETERS - D.22
RDB$REF_CONSTRAINTS - D.23
RDB$RELATIONS - D.24
RDB$RELATION_CONSTRAINTS - D.25
RDB$RELATION_FIELDS - D.26
RDB$ROLES - D.27
RDB$SECURITY_CLASSES - D.28
RDB$TRANSACTIONS - D.29
RDB$TRIGGERS - D.30
RDB$TRIGGER_MESSAGES - D.31
RDB$TYPES - D.32
RDB$USER_PRIVILEGES - D.33
RDB$VIEW_RELATIONS
- D.1
- Appendix E. Monitoring Tables
- Appendix F. Character Sets and Collation Sequences
- Appendix G. License notice
- Appendix H. Document History