Sybase 12.4.2 manual Sysdomain

CHAPTER 1 Overview of Adaptive Server IQ System Administration

System table	Description
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

13