com/FirebirdSQL/firebird-documentation/issues or submit a pull request with the necessary changes. Preface 1 Table of Contents 1. About the Firebird 4.0 Language Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 Table of Contents 2 3.4.6. Operations Using Date and Time Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Table of Contents 3 4.2.3. Existential Predicates. . . . . . . . . . . . . . . . . . . . . . . . . .

other languages would proceed under the auspices of the Firebird Documentation Project. Preface 1 Table of Contents 1. About the Firebird SQL Language Reference: for Firebird 2.5 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Table of Contents 2 3.5.2. Client Character Set . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Table of Contents 3 5.3.3. DROP DOMAIN . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

................ 111 TABLE .................................................................................................................................... 112 CREATE TABLE ..................... Примеры использования внешних таблиц ................................................. 126 ALTER TABLE ................................................................................................. ...................................................................................... 134 DROP TABLE .................................................................................................

Kamala Vadlamani, Paul Vinkenoog, Norman Dunbar, Mark Rotteveel Version 1.0, 24 December 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Table of Contents 1 18.2. SET AUTOddl. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 Table of Contents 2 19.17. Show Secclasses . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Null Guide NULL behaviour and pitfalls in Firebird SQL Paul Vinkenoog Version 1.2, 30 June 2020 Table of Contents 1. What is NULL? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Table of Contents 1 9.3. WHILE loops . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 15.1. Adding a non-nullable field to a populated table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44 15.1.1. Adding

5.4. TABLE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 5.4.1. CREATE TABLE . . . 117 5.4.2. ALTER TABLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 134 5.4.3. DROP TABLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 141 5.4.4. RECREATE TABLE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Firebird Internals Inside a Firebird Database Norman Dunbar Version 1.2, 13 August 2021 Table of Contents 1. Introduction. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62 Table of Contents 1 Chapter 1. Introduction The purpose of this document is to try to explain what goes 0x04 Pointer Page. Each table has one or more of these and this page type keeps track of all the pages that make up the table. Pointer pages are owned by one and only one table, there is no sharing allowed

ALTER SEQUENCE SET GENERATOR DROP SEQUENCE DROP GENERATOR TABLE 3 Руководство по языку SQL CREATE TABLE ALTER TABLE RECREATE TABLE TRIGGER CREATE TRIGGER ALTER TRIGGER CREATE OR ALTER TRIGGER тире до конца строки игнорируется. Пример: -- Таблица для хранения информации о клиентах: CREATE TABLE CUSTOMERS ( NAME VARCHAR(32), ADDED_BY VARCHAR(24), CUSTNO VARCHAR(8), PURCHASES INTEGER -- количество Более короткие шестнадцатеричные числа интерпретируются как тип данных INTEGER. Пример: CREATE TABLE WHOLELOTTARECORDS ( ID BIGINT NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR(32) ) INSERT INTO MYBIGINTS

dialect n 0 335544875 bad_debug_format Bad debug info format -84 335544554 nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL 336397218 dsql_derived_table_more_columns Column list from derived table @1 has more columns than the number of items in its SELECT statement -104 336397219 dsql_derived_table_less_columns Column list from derived table @1 has less columns than the number of items in its SELECT statement -104 336397220 dsql_derived_field_unnamed No column name specified for column number @1 in derived table @2 -104 336397221

335741039 gfix_opt_SQL_dialect -sql_dialect set database dialect n -84 335544554 nonsql_security_rel Table/procedure has non-SQL security class defined -84 335544555 nonsql_security_fld Column has non-SQL part does not exist in input datatype -150 335544360 read_only_rel Attempted update of read-only table -150 335544362 read_only_view Cannot update read-only view %s -150 335544446 non_updatable Not updatable 335544359 read_only_field Attempted update of read-only column -155 335544658 dsql_base_table %s is not a valid base table of the specified view -157 335544598 specify_field_err Must specify column name for