Describes the procedures, functions, and user-defined types in the database.
| Column Name | Type | Length | Nullability | 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 | LONGVARCHAR | 255 | 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 | ?? | 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 |