991
CHAPTER 15
System Tables
The structure of every database is described in a number of system tables.
The Entity-Relationship diagram on the next page shows all the system
tables and the foreign keys that connect them.
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.
Topic Page
System tables diagram 993
System table descriptions 995
DUMMY system table 996
SYSARTICLE system table 997
SYSARTICLECOL system table 998
SYSCAPABILITY system table 999
SYSCAPABILITYNAME system table 1000
SYSCOLLATION system table 1001
SYSCOLLATIONMAPPINGS system table 1002
SYSCOLPERM system table 1003
SYSCOLUMN system table 1004
SYSDOMAIN system table 1006
SYSEXTENT system table 1007
SYSEXTERNLOGINS system table 1008
SYSFILE system table 1009
SYSFKCOL system table 1010
SYSFOREIGNKEY system table 1011
About this chapter
Contents
To Next Page
Loading...