Optional Parameters

From InterBase
Jump to: navigation, search

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 USER and 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.

For a complete discussion of all CREATE DATABASE parameters, see the Data Definition Guide. For the complete syntax of CREATE DATABASE, see Language Reference Guide.

Important: An application that creates a database must be preprocessed with the gpre -m switch. 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 TABLE before creating and populating them. For more information about table creation, see Creating a Table.