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


SYSDBFILE system view

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:

ALTER DBSPACE dbspace RENAME 'new-filename';
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