Sybase Adaptive Server Anywhere - SYSTABLE System Table

Chapter 15 System Tables
1039
SYSTABLE system table
Column name
Column
type
Column
constraint
Table constraints
table_id UNSIGNED
INT
NOT NULL Primary key
file_id UNSIGNED
INT
NOT NULL Foreign key references
SYSFILE
count INTEGER NOT NULL
first_page INTEGER NOT NULL
last_page INTEGER NOT NULL
primary_root INTEGER NOT NULL
creator UNSIGNED
INT
NOT NULL Unique index.
Foreign key references
SYSUSERPERM.user_id
table_name CHAR(128) NOT NULL Unique index
table_type CHAR(10) NOT NULL
view_def LONG
VARCHAR
remarks LONG
VARCHAR
replicate CHAR(1) NOT NULL
existing_obj CHAR(1)
remote_location LONG
VARCHAR
remote_objtype CHAR(1)
srvid INTEGER Foreign key references
SYSSERVERS
Each row of SYSTABLE describes one table or view in the database.
table_id Each table or view is assigned a unique number (the table
number) which is the primary key for SYSTABLE.
file_id Indicates which database file contains the table. The file_id is a
FOREIGN KEY for SYSFILE.