Firebird Create database



Syntax

CREATE DATABASE <file name>
    [ PAGE_SIZE <page size> ]
    [ LENGTH = <length> ]
    [ USER <user name> ]
    [ PASSWORD <user password> ]
    [ SET NAMES <charset name> ]
    [ DEFAULT CHARACTER SET <charset name> [ COLLATION <collation name> ] ]
    [ DIFFERENCE FILE <file name> ]

Default COLLATION (version 2.5)

Specify the default collation of the default character set.

 

Example

SQL>CREATE DATABASE 'D:\data\test.fdb' page_size 8192 user
'SYSDBA' password 'masterkey';

SQL>SELECT * FROM RDB$RELATIONS;