Derby System Tables

Derby includes the following system tables:

• SYSALIASES
• SYSCHECKS
• SYSCOLUMNS
• SYSCONGLOMERATES
• SYSCONSTRAINTS
• SYSDEPENDS
• SYSFILES
• SYSFOREIGNKEYS
• SYSKEYS
• SYSSCHEMAS
• SYSSTATISTICS
• SYSSTATEMENTS
• SYSTABLES
• SYSTRIGGERS
• SYSVIEWS

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.

The recommended way to get more information about these tables is to use an instance of the Java interfacejava.sql.DatabaseMetaData.