ASA SQL Reference
System Tables
| 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 | |
| store_type | CHAR(8) | 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.
store_type This field is for internal use.