Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Reference » Views » System views


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