Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
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.|
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.|
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|