Reference Manual
CHAPTER 15. System Tables
Column name |
Column type |
Column constraint |
Table constraint |
|---|---|---|---|
file_id |
SMALLINT |
NOT NULL |
Primary key |
file_name |
LONG VARCHAR |
NOT NULL |
|
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.