System Tables

The structure of every Sybase IQ database is described in a number of system tables. The system tables are designed for internal use.

The DUMMYsystem table is the only system table you are permitted to access directly. For all other system tables, you access their underlying data through their corresponding views.

List of system tables

System table

Internal use only?

DUMMY

No

ISYSARTICLE

Yes

ISYSARTICLECOL

Yes

ISYSATTRIBUTE

Yes

ISYSATTRIBUTENAME

Yes

ISYSCAPABILITY

Yes

ISYSCHECK

Yes

ISYSCOLPERM

Yes

ISYSCOLSTAT

Yes

ISYSCONSTRAINT

Yes

ISYSDBFILE

Yes

ISYSDBSPACE

Yes

ISYSDBSPACEPERM

Yes

ISYSDEPENDENCY

Yes

ISYSDOMAIN

Yes

ISYSEVENT

Yes

ISYSEXTERNENV

Yes

ISYSEXTERNENVOBJECT

Yes

ISYSEXTERNLOGIN

Yes

ISYSFKEY

Yes

ISYSGROUP

Yes

ISYSHISTORY

Yes

ISYSIDX

Yes

ISYSIDXCOL

Yes

ISYSIQBACKUPHISTORY

Yes

ISYSIQBACKUPHISTORYDETAIL

Yes

ISYSIQDBFILE

Yes

ISYSIQDBSPACE

Yes

ISYSIQIDX

Yes

ISYSIQINFO

Yes

ISYSIQJOINIDX

Yes

ISYSIQJOINIXCOLUMN

Yes

ISYSIQLOGICALSERVER

Yes

ISYSIQLOGINPOLICYLSINFO

Yes

ISYSIQLSLOGINPOLICYOPTION

Yes

ISYSIQLSMEMBER

Yes

ISYSIQLSPOLICY

Yes

ISYSIQLSPOLICYOPTION

Yes

ISYSIQMPXSERVER

Yes

ISYSIQPARTITIONCOLUMN

Yes

ISYSIQTAB

Yes

ISYSIQTABCOL

Yes

ISYSJAR

Yes

ISYSJARCOMPONENT

Yes

ISYSJAVACLASS

Yes

ISYSLOGINMAP

Yes

ISYSLOGINPOLICY

Yes

ISYSLOGINPOLICYOPTION

Yes

ISYSMVOPTION

Yes

ISYSMVOPTIONNAME

Yes

ISYSOBJECT

Yes

ISYSOPTION

Yes

ISYSOPTSTAT

Yes

ISYSPARTITION

Yes

ISYSPARTITIONKEY

Yes

ISYSPARTITIONSCHEME

Yes

ISYSPHYSIDX

Yes

ISYSPROCEDURE

Yes

ISYSPROCPARM

Yes

ISYSPROCPERM

Yes

ISYSPROXYTAB

Yes

ISYSPUBLICATION

Yes

ISYSREMARK

Yes

ISYSREMOTEOPTION

Yes

ISYSREMOTEOPTIONTYPE

Yes

ISYSREMOTETYPE

Yes

ISYSREMOTEUSER

Yes

ISYSSCHEDULE

Yes

ISYSSERVER

Yes

ISYSSOURCE

Yes

ISYSSQLSERVERTYPE

Yes

ISYSSUBPARTITIONKEY

Yes

ISYSSUBSCRIPTION

Yes

ISYSSYNC

Yes

ISYSSYNCPROFILE

Yes

ISYSSYNCSCRIPT

Yes

ISYSTAB

Yes

ISYSTABCOL

Yes

ISYSTABLEPERM

Yes

ISYSTEXTCONFIG

Yes

ISYSTEXTIDX

Yes

ISYSTEXTIDXTAB

Yes

ISYSTRIGGER

Yes

ISYSTYPEMAP

Yes

ISYSUSER

Yes

ISYSUSERAUTHORITY

Yes

ISYSUSERMESSAGE

Yes

ISYSUSERTYPE

Yes

ISYSVIEW

Yes

ISYSWEBSERVICE

Yes