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 commands 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 commands.
System tables in SQL Anywhere are exposed via their corresponding views.
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
ISYSFILE 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
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
ISYSSERVER system table
ISYSSOURCE system table
ISYSSQLSERVERTYPE system table
ISYSSUBSCRIPTION system table
ISYSSYNC 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
ISYSUSER system table
ISYSUSERAUTHORITY system table
ISYSUSERMESSAGE system table
ISYSUSERTYPE system table
ISYSVIEW system table
ISYSWEBSERVICE system table
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |