SYSALIASES system table

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)



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