<< CLOSE CONNECTION | IBEBlock | DROP DATABASE >>

CREATE DATABASE

Syntax

  CREATE DATABASE 'filespec' USER 'username' PASSWORD 'password'
     [CLIENTLIB 'libfile']
     [SQL_DIALECT dialect]
     [PAGE_SIZE int]
     [DEFAULT CHARACTER SET charset]
ArgumentDescription
'filespec'A new database file specification; file naming conventions are platform-specific.
USER 'username'Checks the username against valid user name and password combinations in the security database (Server security ISC4.GDB / SECURITY.FDB) on the server where the database will reside.
PASSWORD 'password'Checks the password against valid user name and password combinations in the security database on the server where the database will reside; can be up to 8 characters.
CLIENTLIB 'libfile'Client library file name; default: gds32.dll.
SQL_DIALECT dialectThe SQL Dialect for the new database, either 1, 2, or 3.
PAGE_SIZE intSize, in bytes, for database pages; int can be 1024 (default), 2048, 4096, or 8192.
DEFAULT CHARACTER SET charsetSets default character set for a database; charset is the name of a character set; if omitted, character set defaults to NONE.

Example

  execute IBEBlock
  as
  begin
    CREATE DATABASE 'localhost:c:\db2.fdb'
    USER 'SYSDBA' PASSWORD 'masterkey'
    PAGE_SIZE 4096 SQL_DIALECT 3
    DEFAULT CHARACTER SET WIN1251
    CLIENTLIB 'C:\Program Files\Firebird\bin\fbclient.dll';

    CREATE CONNECTION Con1 'localhost:c:\db2.fdb'
    USER 'SYSDBA' PASSWORD 'masterkey'
    CLIENTLIB 'C:\Program Files\Firebird\Bin\fbclient.dll'
    SQL_DIALECT 3 NAMES WIN1251;

    USE Con1;

    ...

    CLOSE CONNECTION Con1;
  end

See also:
Create Database

back to top of page
<< CLOSE CONNECTION | IBEBlock | DROP DATABASE >>