Chapter 15 System Tables
1009
SYSFILE system table
Column name Column type
Column
constraint
Table
constraint
file_id SMALLINT NOT NULL Primary key
file_name LONG
VARCHAR
NOT NULL Unique index
dbspace_name CHAR(128) NOT NULL
Every database consists of one or more operating system files. Each file is
recorded in SYSFILE.
file_id Each file in a database is assigned a unique number. This file
identifier is the primary key for SYSFILE. All system tables are stored in
file_id 0.
file_name The database name is stored when a database is created. This
name is for informational purposes only.
dbspace_name Every file has a dbspace name that is unique. It is used in
the CREATE TABLE command.
To Next Page
Loading...