Structure of the System Catalog

Home | Previous Page | Next Page System Catalog Tables >

Structure of the System Catalog

The following system catalog tables describe the structure of an Informix database. Here * indicates whether IDS, or XPS, or both support the table.

System Catalog Table	XPS	IDS	Page
sysaggregates		*	SYSAGGREGATES (IDS Only)
sysams		*	SYSAMS (IDS Only)
sysattrtypes		*	SYSATTRTYPES (IDS Only)
sysblobs	*	*	SYSBLOBS
syscasts		*	SYSCASTS (IDS Only)
syschecks	*	*	SYSCHECKS
syscheckudrdep		*	SYSCHECKUDRDEP (IDS Only)
syscolattribs		*	SYSCOLATTRIBS (IDS Only)
syscolauth	*	*	SYSCOLAUTH
syscoldepend	*	*	SYSCOLDEPEND
syscolumns	*	*	SYSCOLUMNS
sysconstraints	*	*	SYSCONSTRAINTS
sysdefaults	*	*	SYSDEFAULTS
sysdepend	*	*	SYSDEPEND
sysdistrib	*	*	SYSDISTRIB
sysdomains		*	SYSDOMAINS (IDS Only)
syserrors		*	SYSERRORS (IDS Only)
sysextcols	*		SYSEXTCOLS (XPS Only)
sysextdfiles	*		SYSEXTDFILES (XPS Only)
sysexternal	*		SYSEXTERNAL (XPS Only)
sysfragauth		*	SYSFRAGAUTH (IDS Only)
sysfragments	*	*	SYSFRAGMENTS
sysindexes	*	*	SYSINDEXES
sysindices		*	SYSINDICES (IDS Only)
sysinherits		*	SYSINHERITS (IDS Only)
syslangauth		*	SYSLANGAUTH (IDS Only)
syslogmap		*	SYSLOGMAP (IDS Only)
sysnewdepend	*		SYSNEWDEPEND (XPS Only)
sysobjstate		*	SYSOBJSTATE (IDS Only)
sysopclasses		*	SYSOPCLASSES (IDS Only)
sysopclstr	*	*	SYSOPCLSTR
sysprocauth	*	*	SYSPROCAUTH
sysprocbody	*	*	SYSPROCBODY
sysprocedures	*	*	SYSPROCEDURES
sysprocplan	*	*	SYSPROCPLAN
sysreferences	*	*	SYSREFERENCES
sysrepository	*		SYSREPOSITORY (XPS Only)
sysroleauth	*	*	SYSROLEAUTH
sysroutinelangs		*	SYSROUTINELANGS (IDS Only)
syssequences		*	SYSSEQUENCES (IDS Only)
syssynonyms	*	*	SYSSYNONYMS
syssyntable	*	*	SYSSYNTABLE
systabamdata		*	SYSTABAMDATA (IDS Only)
systabauth	*	*	SYSTABAUTH
systables	*	*	SYSTABLES
systraceclasses		*	SYSTRACECLASSES (IDS Only)
systracemsgs		*	SYSTRACEMSGS (IDS Only)
systrigbody	*	*	SYSTRIGBODY
systriggers	*	*	SYSTRIGGERS
sysusers	*	*	SYSUSERS
sysviews	*	*	SYSVIEWS
sysviolations	*	*	SYSVIOLATIONS
sysxtddesc		*	SYSXTDDESC (IDS Only)
systdtypeauth		*	SYSXTDTYPEAUTH (IDS Only)
sysxtdtypes		*	SYSXTDTYPES (IDS Only)

If the database locale is the default (U. S. English, ISO 8859-1 codeset), then the character column types are CHAR and VARCHAR. For all other locales and collation orders, the character column types are national character types, NCHAR and NVARCHAR. For more information about locales and collation order of data types, see the IBM Informix: GLS User's Guide. For more information about SQL data types, see Data Types of this manual.