`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.