The database consists of areas where database objects (tables, indexes, and LOBs) are created. The DDL statements CREATE TABLE, CREATE INDEX, and ALTER TABLE let you specify the area name where new objects of each type are created.

Before you can create and move objects in default areas using SQL, you must set up the default areas. You can define the default area for tables, indexes, and LOBs using the following command:
SET DATABASE DEFAULT AREA area_name FOR [ ALL|TABLE|INDEX|LOB]
Note: You can also use PROUTIL to set up the default areas with the following command:
proutil db-name -C setobjectdefaultarea area-name [ object-type | all ]
You can also view existing default areas with the following command:
SHOW DATABASE DEFAULT AREA [ TABLE | INDEX | LOB ]
Note: You can also use PROUTIL to view the existing default areas with the following command: 
proutil db-name -C dispobjectdefaultarea [ object-type | all ]

After you define default areas for creating new objects, if you do not specify the area name in the DDL statement, then the object is created in the default area defined in the database schema. The default database areas are stored in the first three elements of the array field _db. _db-misc1.