System tables

The structure of every database is described in several system tables. System tables are owned by the user SYS. The contents of these tables can be changed only by the database server. The UPDATE, DELETE, and INSERT statements cannot be used to modify the contents of these tables. Further, the structure of these tables cannot be changed using the ALTER TABLE and DROP statements.

Data in system tables are exposed via their corresponding system views. Each system table name start with capital i (I). Each corresponding system view has the same name but without the i at the beginning.

 See also

DUMMY system table
ISYSARTICLE system table
ISYSARTICLECOL system table
ISYSATTRIBUTE system table
ISYSATTRIBUTENAME system table
ISYSCAPABILITY system table
ISYSCHECK system table
ISYSCOLPERM system table
ISYSCOLSTAT system table
ISYSCONSTRAINT system table
ISYSDEPENDENCY system table
ISYSDBFILE system table
ISYSDBSPACE system table
ISYSDBSPACEPERM system table
ISYSDOMAIN system table
ISYSEVENT system table
ISYSEXTERNLOGIN system table
ISYSFKEY system table
ISYSGROUP system table
ISYSHISTORY system table
ISYSIDX system table
ISYSIDXCOL system table
ISYSJAR system table
ISYSJARCOMPONENT system table
ISYSJAVACLASS system table
ISYSLOGINMAP system table
ISYSLOGINPOLICY system table
ISYSLOGINPOLICYOPTION system table
ISYSMIRROROPTION system table
ISYSMIRRORSERVER system table
ISYSMIRRORSERVEROPTION system table
ISYSMVOPTION system table
ISYSMVOPTIONNAME system table
ISYSOBJECT system table
ISYSOPTION system table
ISYSOPTSTAT system table
ISYSPHYSIDX system table
ISYSPROCEDURE system table
ISYSPROCPARM system table
ISYSPROCPERM system table
ISYSPROXYTAB system table
ISYSPUBLICATION system table
ISYSREMARK system table
ISYSREMOTEOPTION system table
ISYSREMOTEOPTIONTYPE system table
ISYSREMOTETYPE system table
ISYSREMOTEUSER system table
ISYSSCHEDULE system table
ISYSSEQUENCE system table
ISYSSEQUENCEPERM system table
ISYSSERVER system table
ISYSSOURCE system table
ISYSSPATIALREFERENCESYSTEM system table
ISYSSQLSERVERTYPE system table
ISYSSUBSCRIPTION system table
ISYSSYNC system table
ISYSSYNCPROFILE system table
ISYSSYNCSCRIPT system table
ISYSTAB system table
ISYSTABCOL system table
ISYSTEXTCONFIG system table
ISYSTEXTIDX system table
ISYSTEXTIDXTAB system table
ISYSTABLEPERM system table
ISYSTRIGGER system table
ISYSTYPEMAP system table
ISYSUNITOFMEASURE system table
ISYSUSER system table
ISYSUSERAUTHORITY system table
ISYSUSERMESSAGE system table
ISYSUSERTYPE system table
ISYSVIEW system table
ISYSWEBSERVICE system table