There are optional parameters for
CREATE DATABASE. For example, when an application running on a client attempts to connect to an InterBase server in order to create a database, it may be expected to provide
PASSWORD parameters before the connection is established. Other parameters specify the database page size, the number and size of multi-file databases, and the default character set for the database.
- Important: An application that creates a database must be preprocessed with the
gpre -mswitch. It must also create at least one table. If a database is created without a table, it cannot be successfully opened by another program. Applications that perform both data definition and data manipulation must declare tables with
DECLARE TABLEbefore creating and populating them. For more information about table creation, see Creating a Table.