Library /sys$common/syshlp/SQL$HELP_OLD72.HLB  —  SHOW  Arguments  STORAGE_AREAS
    Displays information about storage areas. If you do not specify a
    wildcard or list of storage area names, SQL displays the names of
    all the storage areas in all attached databases.

    You
    Specify
    This:       SQL Displays Information About:

    USAGE       Usage, object name, storage map, and storage map
                partition number for the specified storage area.
                Partition numbers are always shown in parentheses,
                and may be accompanied by a storage map name. For
                example, for an index there is no special map because
                it is part of the index. For a table, the map is an
                extra object and therefore is reported.
    ATTRIBUTES  Storage area type, access, page format, page size,
                storage area file, storage area allocation, storage
                area extent minimum and maximum, storage area extent
                percent, snapshot file, snapshot allocation, snapshot
                extent minimum and maximum, snapshot extent percent,
                whether extents are enabled or disabled, and the
                locking level for the specified storage area.
Close Help