Each row in the SYSDBFILE system view describes a dbspace file. The underlying system table for this view is ISYSDBFILE.
| Column name | Data type | Description | ||
|---|---|---|---|---|
| dbfile_id | SMALLINT | For internal use only. | ||
| dbspace_id | SMALLINT | Each dbspace file in a database is assigned a unique number. The system dbspace contains all system objects and has a dbspace_id of 0. | ||
| dbfile_name | CHAR(128) |
The file name for the dbspace. For dbspaces other than system and TEMPORARY, the file name can be changed using the following statement:
|
||
| file_name | LONG VARCHAR | A unique name for the dbspace. It is used in the CREATE TABLE command. | ||
| lob_map | LONG VARBIT | For internal use only. |
Constraints on underlying system table |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |