Sets the default area for tables, indexes, and LOBs.

Syntax

SET DATABASE DEFAULT AREA area_name FOR [ ALL|TABLE|INDEX|LOB ];

Parameters

  • SET DATABASE DEFAULT AREA—Sets the default area for an object.
  • area-name—Specifies the name of the storage area for which you want to create a default area.
  • ALL—Specifies that all objects (tables, indexes, and LOBs) are created in the default area.
Note: You can use the same command to change the default areas. This command replaces the existing default area for the objects with a new default area.