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.
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 |