![WRITETEXT statement [T-SQL]](gif/backward.gif)
The structure of every database is described in a number of system tables.
The system tables are owned by the SYS user ID. The contents of these tables can be changed only by the database system. 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.
This chapter contains descriptions of each of the system tables. Several of the columns have only two possible values. Usually these values are "Y" and "N" for "yes" and "no" respectively. These columns are designated by "(Y/N)".
DUMMY system table
RowGenerator system table
SYSARTICLE system table
SYSARTICLECOL system table
SYSATTRIBUTE system table
SYSATTRIBUTENAME system table
SYSCAPABILITY system table
SYSCAPABILITYNAME system table
SYSCHECK system table
SYSCOLLATION system table
SYSCOLLATIONMAPPINGS system table
SYSCOLPERM system table
SYSCOLSTAT system table
SYSCOLUMN system table
SYSCONSTRAINT system table
SYSDOMAIN system table
SYSEVENT system table
SYSEVENTTYPE system table
SYSEXTENT system table
SYSEXTERNLOGINS system table
SYSFILE system table
SYSFKCOL system table
SYSFOREIGNKEY system table
SYSGROUP system table
SYSINDEX system table
SYSINFO system table
SYSIXCOL system table
SYSJAR system table
SYSJARCOMPONENT system table
SYSJAVACLASS system table
SYSLOGIN system table
SYSOPTBLOCK system table
SYSOPTION system table
SYSOPTJOINSTRATEGY system table
SYSOPTORDER system table
SYSOPTQUANTIFIER system table
SYSOPTREQUEST system table
SYSOPTREWRITE system table
SYSOPTSTAT system table
SYSPROCEDURE system table
SYSPROCPARM system table
SYSPROCPERM system table
SYSPUBLICATION system table
SYSREMOTEOPTION system table
SYSREMOTEOPTIONTYPE system table
SYSREMOTETYPE system table
SYSREMOTEUSER system table
SYSSCHEDULE system table
SYSSERVERS system table
SYSSQLSERVERTYPE system table
SYSSUBSCRIPTION system table
SYSSYNC system table
SYSTABLE system table
SYSTABLEPERM system table
SYSTRIGGER system table
SYSTYPEMAP system table
SYSUSERMESSAGES system table
SYSUSERPERM system table
SYSUSERTYPE system table
SYSWEBSERVICE system table
Other system tables