Sybase 12.4.2 - Manual (Page 33)

CHAPTER 1 Overview of Adaptive Server IQ System Administration
13
SYSDOMAIN Lists the number, name, ODBC type,
and precision of each predefined data
type
SYSFILE Lists operating system files and
dbspace names for the database
SYSFKCOL Associates each foreign key column
with a primary key column
SYSFOREIGNKEY Contains general information about
each foreign key
SYSGROUP Describes a many-to-many
relationship between groups and
members
SYSINDEX Describes indexes in the database
SYSINFO Describes database characteristics
SYSIQBACKUP Lists backups and restores
SYSIQCOLUMN Lists information on columns in every
table or view in the IQ Store
SYSIQFILE Lists information on operating system
files for the database
SYSIQINDEX Lists internal information on indexes
in the database
SYSIQINFO Lists additional database
characteristics
SYSIQJINDEX Describes join indexes in the database
SYSIQJOINIXCOLUMN Describes columns that participate in
join indexes
SYSIQJOINIXTABLE Lists the tables that participate in each
join index in the database
SYSIQTABLE Describes each table or view in the IQ
Store
SYSIXCOL Describes each index for each column
in the database
SYSJAR Describes each jar file associated with
the database
SYSJARCOMPONENT Describes each jar component
associated with the database
SYSJAVACLASS Contains all information related to
Java classes
System table Description