Displays the default areas for table, index, and LOBs.

Syntax

SHOW DATABASE DEFAULT AREA [ ALL | TABLE | INDEX | LOB ];

Parameters

  • SHOW DATABASE DEFAULT AREA—Displays the default area for an object.
  • ALL | TABLE | INDEX | LOB —The object for which you want to display the default area. You can view the default areas for all objects by using ALL or for specific objects by using TABLE, INDEX, or LOB
Note: If you did not set the default area for any object type, then this command returns an empty result.