Sybase Adaptive Server Anywhere - System Tables Diagram

Chapter 15 System Tables
993
System tables diagram
The Adaptive Server Anywhere system tables are shown in the following
diagrams. Arrows indicate foreign key relations between tables: the arrow
leads from the foreign table to the primary table.
The first diagram shows the core set of system tables.
SYSCOLLATION
COLLATION_ID
COLLATION_LABEL
COLLATION_NAME
COLLATION_ORDER
SYSUSERMESSAGES
ERROR
UID
DESCRIPTION
LANGID
SYSSQLSERVERTYPE
SS_USER_TYPE
SS_DOMAIN_ID
SS_TYPE_NAME
PRIMARY_SA_DOMAIN_ID
PRIMARY_SA_USER_TYPE
SYSCOLLATIONMAPPINGS
COLLATION_LABEL
COLLATION_NAME
CS_LABEL
SO_CASE_LABEL
SO_CASELESS_LABEL
JDK_LABEL
DUMMY
DUMMY_COL
SYSINFO
PAGE_SIZE
ENCRYPTION
BLANK_PADDING
CASE_SENSITIVITY
DEFAULT_COLLATION
DATABASE_VERSION
CLASSES_VERSION
SYSFILE
FILE_ID
FILE_NAME
DBSPACE_NAME
SYSTABLE
TABLE_ID
FILE_ID
COUNT
FIRST_PAGE
LAST_PAGE
PRIMARY_ROOT
CREATOR
TABLE_NAME
TABLE_TYPE
VIEW_DEF
REMARKS
REPLICATE
EXISTING_OBJ
REMOTE_LOCATION
REMOTE_OBJTYPE
SRVID
SYSFOREIGNKEY
FOREIGN_TABLE_ID
FOREIGN_KEY_ID
PRIMARY_TABLE_ID
ROOT
CHECK_ON_COMMIT
NULLS
ROLE
REMARKS
SYSFKCOL
FOREIGN_TABLE_ID
FOREIGN_KEY_ID
FOREIGN_COLUMN_ID
PRIMARY_COLUMN_ID
SYSTRIGGER
TRIGGER_ID
TABLE_ID
EVENT
TRIGGER_TIME
TRIGGER_ORDER
FOREIGN_TABLE_ID
FOREIGN_KEY_ID
REFERENTIAL_ACTION
TRIGGER_NAME
TRIGGER_DEFN
REMARKS
SYSEXTENT
FILE_ID
EXTENT_ID
FIRST_PAGE
LAST_PAGE
FILE_NAME
SYSDOMAIN
DOMAIN_ID
DOMAIN_NAME
TYPE_ID
PRECISION
SYSCOLUMN
TABLE_ID
COLUMN_ID
PKEY
DOMAIN_ID
NULLS
WIDTH
SCALE
ESTIMATE
COLUMN_NAME
REMARKS
DEFAULT
CHECK
USER_TYPE
FORMAT_STR
COLUMN_TYPE
REMOTE_NAME
REMOTE_TYPE
SYSPROCPARM
PROC_ID
PARM_ID
PARM_TYPE
PARM_MODE_IN
PARM_MODE_OUT
DOMAIN_ID
WIDTH
SCALE
PARM_NAME
REMARKS
DEFAULT
USER_TYPE
SYSUSERTYPE
TYPE_ID
CREATOR
DOMAIN_ID
NULLS
WIDTH
SCALE
TYPE_NAME
DEFAULT
CHECK
FORMAT_STR
SUPER_TYPE_ID
SYSTYPEMAP
SS_USER_TYPE
SA_DOMAIN_ID
SA_USER_TYPE
NULLABLE
SYSUSERPERM
USER_ID
USER_NAME
PASSWORD
RESOURCEAUTH
DBAAUTH
SCHEDULEAUTH
PUBLISHAUTH
REMOTEDBAAUTH
USER_GROUP
REMARKS
SYSEXTERNLOGINS
USER_ID
SRVID
REMOTE_LOGIN
REMOTE_PASSWORD
SYSINDEX
TABLE_ID
INDEX_ID
ROOT
FILE_ID
UNIQUE
CREATOR
INDEX_NAME
REMARKS
SYSIXCOL
TABLE_ID
INDEX_ID
SEQUENCE
COLUMN_ID
ORDER
SYSTABLEPERM
STABLE_ID
GRANTEE
GRANTOR
TTABLE_ID
SELECTAUTH
INSERTAUTH
DELETEAUTH
UPDATEAUTH
UPDATECOLS
ALTERAUTH
REFERENCEAUTH
SYSCOLPERM
TABLE_ID
GRANTEE
GRANTOR
COLUMN_ID
PRIVILEGE_TYPE
IS_GRANTABLE
SYSOPTION
USER_ID
OPTION
SETTING
SYSGROUP
GROUP_ID
GROUP_MEMBER
SYSLOGIN
INTEGRATED_LOGIN_ID
LOGIN_UID
REMARKS
SYSPROCEDURE
PROC_ID
CREATOR
PROC_NAME
PROC_DEFN
REMARKS
REPLICATE
SYSPROCPERM
PROC_ID
GRANTEE
SYSSERVERS
SRVID
SRVNAME
SRVCLASS
SRVINFO
SRVREADONLY