# 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 system table
- SYSCHECKS system table
- SYSCOLPERMS system table
  The SYSCOLPERMS table stores the column permissions that have been granted but not revoked.
- SYSCOLUMNS system table
- SYSCONGLOMERATES system table
- SYSCONSTRAINTS system table
- SYSDEPENDS system table
  The SYSDEPENDS table stores the dependency relationships between persistent objects in the database.
- SYSFILES system table
- SYSFOREIGNKEYS system table
- SYSKEYS system table
- SYSPERMS system table
  The SYSPERMS system table describes the USAGE permissions for sequence generators and user-defined types.
- SYSROLES system table
  The SYSROLES table stores the roles in the database.
- SYSROUTINEPERMS system table
  The SYSROUTINEPERMS table stores the permissions that have been granted to routines.
- SYSSCHEMAS system table
- SYSSEQUENCES system table
  The SYSSEQUENCES system table describes the sequence generators in the database.
- SYSSTATISTICS system table
- SYSSTATEMENTS system table
- SYSTABLEPERMS system table
  The SYSTABLEPERMS table stores the table permissions that have been granted but not revoked.
- SYSTABLES system table
- SYSTRIGGERS system table
- SYSVIEWS system table