You must create the database before you can create any tables or other objects that the database contains.
When an Informix database server creates a database, it sets up records that show the existence of the database and its mode of logging. The database server manages disk space directly, so these records are not visible to operating-system commands.
When you create a database with Extended Parallel Server, logging is always turned on. However, you can create nonlogging tables within the database. For more information, see Configuring the Database Server to Use Distributed Queries.
The following statement shows the syntax you use to create a database that is called sales_demo:
CREATE DATABASE sales_demoHome | [ Top of Page | Previous Page | Next Page | Contents | Index ]