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. |
| object_id | UNSIGNED BIGINT |
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 |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |