Using CREATE DATABASE

Go Up to Creating a Database (Data Definition Guide)

CREATE DATABASE establishes a new database and populates its system tables, which are the tables that describe the internal structure of the database. CREATE DATABASE must occur before creating database tables, views, and indexes.

CREATE DATABASE optionally allows you to do the following:

• Specify a user name and a password
• Change the default page size of the new database
• Specify a default character set for the database
• Add secondary files to expand the database

CREATE DATABASE must be the first statement in the data definition file.

Important: In DSQL, CREATE DATABASE can be executed only with EXECUTE IMMEDIATE. The database handle and transaction name, if present, must be initialized to zero prior to use.

The syntax for CREATE DATABASE is:

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

Important: Use single quotes to delimit strings such as file names, user names, and passwords.

Topics

• Creating a Single-file Database
• Creating a Multifile Database
• Using LENGTH to Specify a Secondary File
• Specifying the Starting Page Number of a Secondary File
• Specifying User Name and Password (Using CREATE DATABASE)
• Specifying Database Page Size
• Specifying the Default Character Set
• When there is No Default Character Set