Chapter 9: System Tables

About this chapter

The structure of every Sybase IQ database is described in a number of system tables. The Entity-Relationship diagrams at the start of this chapter show all the system tables and the foreign keys connecting the system tables.

System tables are owned by the SYS user ID. The contents of these tables can be changed only by the database system. Thus, you cannot use the UPDATE, DELETE, and INSERT commands to modify the contents of these tables. Further, you cannot change the structure of these tables using the ALTER TABLE and DROP commands.