Cloudscape System Tables
Page 1 of 17

4
Cloudscape System Tables

Cloudscape includes the following system tables:

You can query system tables, but you cannot alter them.

All system tables reside in the SYS schema. Because this is not the default schema, qualify all queries accessing the system tables with the SYS schema name.

You can also use an instance of the Java interface java.sql.DatabaseMetaData to get more information about these tables.

Some system tables store Java objects, so to get information from those tables you will need to examine the Java class that the column is defined to serialize. If a column serializes a Java class or interface, the class name or interface name is a link to the javadoc for that class. For more information, see Using the Cloudscape Types to Query the System Tables in the Cloudscape Developer's Guide.

Small entity-relationship diagram

Large entity-relationship diagram