Describes the procedures and functions in the database.
Column Name
Type
Length
Nullability
Contents
ALIASID
CHAR
36
false
unique identifier for the alias
ALIAS
VARCHAR
128
false
alias
SCHEMAID
CHAR
36
true
reserved for future use
JAVACLASSNAME
LONGVARCHAR
255
false
the Java class name
ALIASTYPE
CHAR
1
false
'F' (function)'P' (procedure)
NAMESPACE
CHAR
1
false
'F' (function)'P' (procedure)
SYSTEMALIAS
BOOLEAN
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
true
A Java interface that encapsulates the additional information
that is specific to an alias
SPECIFICNAME
VARCHAR
128
false
system-generated identifier