# Derby System Tables

Derby includes system tables.

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

All of the above 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 interface java.sql.DatabaseMetaData.

- SYSALIASES
- SYSCHECKS
- SYSCOLPERMS
  The SYSCOLPERMS table stores the column permissions that have been granted but not revoked.
- SYSCOLUMNS
- SYSCONGLOMERATES
- SYSCONSTRAINTS
- SYSDEPENDS
  The SYSDEPENDS table stores the dependency relationships between persistent objects in the database.
- SYSFILES
- SYSFOREIGNKEYS
- SYSKEYS
- SYSROUTINEPERMS
  The SYSROUTINEPERMS table stores the permissions that have been granted to routines.
- SYSSCHEMAS
- SYSSTATISTICS
- SYSSTATEMENTS
- SYSTABLEPERMS
  The SYSTABLEPERMS table stores the table permissions that have been granted but not revoked.
- SYSTABLES
- SYSTRIGGERS
- SYSVIEWS