Firebird 2.0
PHP5 Programming
Manual

CREATE SYNTAX

Purpose

Use the create syntax to create a new database with the fbird_query function. It is the same as the syntax used by isql.

Syntax

CREATE {DATABASE | SCHEMA} 'filespec'
   [USER 'username' [PASSWORD 'password']]
   [PAGE_SIZE [=] int]
   [LENGTH [=] int [PAGE[S]]]
   [DEFAULT CHARACTER SET charset]
   [<secondary_file>];

<secondary_file> ::=
   FILE 'filespec' [<fileinfo>] [<secondary_file>]

<fileinfo> ::=
   { LENGTH [=] int [PAGE[S]] | STARTING [AT [PAGE]] int }
   [<fileinfo>]


Argument 
Description
`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 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

PAGE_SIZE [=] int

Size, in bytes, for database pages; int can be 1024 (default), 2048, 4096, or 8192

DEFAULT CHARACTER SET

Sets default character set for a database charset charset is the name of a character set; if omitted, character set defaultsto NONE

FILE `filespec'

Names one or more secondary files to hold database pages after the primary file is filled. For databases created on remote servers, secondary file specifications cannot include a node name.

STARTING [AT [PAGE]] int

Specifies the starting page number for a secondary file.

LENGTH [=] int [PAGE[S]]

Specifies the length of a primary or secondary database file. Use for primary file only if defining a secondary file in the same statement.


previous page goto index next page

Legal information