Each row in the SYSDBSPACE system view describes a dbspace file. The underlying system table for this view is ISYSDBSPACE.
|Column name||Column type||Description|
|dbspace_id||SMALLINT||Unique number identifying the dbspace. The system dbspace contains all system objects and has a dbspace_id of 0.|
|object_id||UNSIGNED BIGINT||The file name for the dbspace. For the system dbspace, the value is the name of the database file when the database was created
and is for informational purposes only; it cannot be changed. For other dbspaces, the file name can be changed using the following
|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.|
PRIMARY KEY (dbspace_id)
FOREIGN KEY (object_id) references SYS.ISYSOBJECT MATCH UNIQUE FULL
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|