The RDB$STORAGE_MAP_AREAS system table contains information about each storage area to which a storage map refers. The following table provides information on the columns of the RDB$STORAGE_MAP_ AREAS system table. Data Column Name Type Summary Description RDB$MAP_NAME char(31) The name of the storage map. RDB$AREA_NAME char(31) The name of the storage area referred to by the storage map. RDB$ROOT_DBK char(8) A pointer to the root of the SORTED index, if it is a SORTED index. RDB$ORDINAL_POSITION integer The order of the storage area represented by this row in the map. RDB$STORAGE_ID integer For a table, a pointer to the database logical area. For a hashed index, a pointer to the system record. RDB$INDEX_ID integer A pointer to the index logical area. RDB$STORAGE_BLR list The BLR that represents of byte the SQL clause, WITH LIMIT varying OF, in the storage map definition. RDB$DESCRIPTION list Description of this of byte partition. varying RDB$EXTENSION_PARAMETERS list Lists table names and of byte column names that are varying referenced by segmented string storage maps. RDB$VERTICAL_PARTITION_ integer For LIST storage maps, INDEX the value indicates the relationship between areas of a LIST storage map area set. RDB$FLAGS integer Flags. RDB$SECURITY_CLASS char(20) Reserved for future use. RDB$PARTITION_NAME char(31) Name of the index or storage map partition.
1 – RDB$FLAGS
Represents flags for RDB$STORAGE_MAP_AREAS system table. Bit Position Description 0 If Bit 0 is clear, the LIST storage area set is filled randomly. If Bit 0 is set, the LIST storage area set is filled sequentially. 1 User named this partition. 2 BUILD PARTITION is required. 3 Deferred build using NOLOGGING.