CREATE DATABASE

<< COMMENT | FB 2.1 Language Reference | ALTER DATABASE >>

CREATE DATABASE

Available in: DSQL, ESQL

Syntax (partial)

 CREATE {DATABASE | SCHEMA}
    ...
    [PAGE_SIZE [=] size]
    ...
    [DIFFERENCE FILE 'filepath']

 size  ::=  4096 | 8192 | 16384
  • If the user supplies a size smaller than 4096, it will be silently converted to 4096. Other numbers not equal to any of the supported sizes will be silently converted to the next lower supported size.

16 Kb page size supported

Changed in: 1.0, 2.1

Description

The maximum database page size has been raised from 8192 to 16384 bytes. In Firebird 2.1 and up, page sizes 1024 and 2048 are deprecated as inefficient. Firebird will no longer create databases with these page sizes, but it will connect to existing small-page databases without any problem.

DIFFERENCE FILE parameter

Added in: 2.0

Description

The DIFFERENCE FILE parameter was added in Firebird 2.0, but not documented at the time. For a full description, see ALTER DATABASE / ADD DIFFERENCE FILE.

See also:
Create Database
CREATE statement
ALTER DATABASE
DROP DATABASE
Page size
DDL - Data Definition Language
Creating your first database

back to top of page
<< COMMENT | FB 2.1 Language Reference | ALTER DATABASE >>