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

SAP Sybase SQL Anywhere 16.0 » 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.

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