Derby system tables
Derby Reference Manual
220
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
The SYSALIASES table describes the procedures, functions, and user-defined types in
the database.
The following table shows the contents of the SYSALIASES system table.
Table 41.
SYSALIASES system table
Column Name
Type
Length
Nullable
Contents
ALIASID
CHAR
36
false
Unique identifier for
the alias
ALIAS
VARCHAR
128
false
Alias (in the case
of a user-defined
type, the name of
the user-defined
type)
SCHEMAID
CHAR
36
true
Reserved for future
use
JAVACLASSNAME
LONG VARCHAR
32,700
false
The Java class
name
ALIASTYPE
CHAR
1
false
'F' (function), 'P'
(procedure), 'A'
(user-defined type)
NAMESPACE
CHAR
1
false
'F' (function), 'P'
(procedure), 'A'
(user-defined type)
SYSTEMALIAS
BOOLEAN
1
false
true (system
supplied or built-in
alias)
false (alias created
by a user)
ALIASINFO
org.apache.derby.
catalog.AliasInfo
This class is not
part of the public
API.
2,147,483,647
true
A Java interface
that encapsulates
the additional
information that is
specific to an alias
