与三个表有关: LOBS LOB_DATA LOB_MAP LOBS: ------------- CREATE CACHED TABLE IF NOT EXISTS INFORMATION_SCHEMA.LOBS (ID BIGINT PRIMARY KEY, BYTE_COUNT BIGINT, TABLE INT) HIDDEN LOB_DATA: ------------- CREATE CACHED TABLE IF NOT EXISTS INFORMATION_SCHEMA.LOB_DATA (BLOCK BIGINT PRIMARY KEY, COMPRESSED INT, DATA BINARY) HIDDEN LOB_MAP: ------------- CREATE CACHED TABLE IF NOT EXISTS INFORMATION_SCHEMA.LOB_MAP (LOB BIGINT, SEQ INT, POS BIGINT, HASH INT, BLOCK BIGINT, PRIMARY KEY(LOB, SEQ)) HIDDEN LOBS表的ID字段和LOB_MAP的LOB字段对应,值一样(就是lobId) 另外还有两个索引: 在LOBS表上的索引: INDEX_LOB_TABLE ------------- CREATE INDEX IF NOT EXISTS INFORMATION_SCHEMA.INDEX_LOB_TABLE ON INFORMATION_SCHEMA.LOBS(TABLE) 在LOB_MAP表上的索引: INDEX_LOB_MAP_DATA_LOB ------------- CREATE INDEX IF NOT EXISTS INFORMATION_SCHEMA.INDEX_LOB_MAP_DATA_LOB ON INFORMATION_SCHEMA.LOB_MAP(BLOCK, LOB) 以上内容对应源代码见: org.h2.store.LobStorage.init()