Each row in the SYSFILE system view describes a dbspace for a database. Every database consists of one or more dbspaces; each dbspace corresponds to an operating system file. The underlying system table for this view is ISYSFILE.
SQL Anywhere automatically creates dbspaces for the main database file, temporary file, transaction log file, and transaction log mirror file, but Information about the temporary file, transaction log, and transaction log mirror dbspaces does not appear in the SYSFILE system view. See Pre-defined dbspaces.
|Column name||Column type||Column constraint|
|file_name||LONG VARCHAR||NOT NULL|
file_id Each file in a database is assigned a unique number. The SYSTEM dbspace contains all system objects and has a file_id of 0.
file_name The file name for the dbspace. For the SYSTEM dbspace, the value is the name of the database file when the database was created and is for informational purposes only; it cannot be changed. For other dbspaces, the file name can be changed using the following statement:
ALTER DBSPACE dbspace RENAME 'new-file-name'
dbspace_name A unique name for the dbspace. It is used in the CREATE TABLE command.
store_type This field is for internal use.
PRIMARY KEY (file_id)