Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » System Objects » 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 Column 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

PRIMARY KEY (dbfile_id)

FOREIGN KEY (dbspace_id) references SYS.ISYSDBSPACE (dbspace_id)