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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSEXTERNLOGIN system view Next Page

SYSFILE system view


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.

Columns
Column name Column type Column constraint
file_id SMALLINT NOT NULL
file_name LONG VARCHAR NOT NULL
dbspace_name CHAR(128) NOT NULL
store_type INTEGER

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.

Constraints on underlying system table

PRIMARY KEY (file_id)