SYSDBSPACE system view

Each row in the SYSDBSPACE system view describes a dbspace file. The underlying system table for this view is ISYSDBSPACE.

Column name Data type Description
dbspace_id SMALLINT Unique number identifying the dbspace. The system dbspace contains all system objects and has a dbspace_id of 0.

The object ID of the dbspace.

dbspace_name CHAR(128) A unique name for the dbspace. It is used in the CREATE TABLE command.
store_type TINYINT For internal use only.
 Constraints on underlying system table