SYSCAT.MODULES catalog view

Each row represents a module.

Table 1. SYSCAT.MODULES Catalog View
Column Name Data Type Nullable Description
MODULESCHEMA VARCHAR (128)   Schema name of the module.
MODULENAME VARCHAR (128)   Unqualified name of the module.
MODULEID INTEGER   Identifier for the module.
DIALECT VARCHAR (10) The source dialect of the SQL module. Possible values are:
  • SQL PL
  • PL/SQL
  • Blank = Not applicable for an alias
OWNER VARCHAR (128)   Authorization ID of the owner of the module.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
MODULETYPE CHAR (1)   Type of module.
  • A = Alias
  • M = Module
  • P = PL/SQL package
BASE_MODULESCHEMA VARCHAR (128) Y If MODULETYPE is 'A', contains the schema name of the module or alias that is referenced by this alias; the null value otherwise.
BASE_MODULENAME VARCHAR (128) Y If MODULETYPE is 'A', contains the unqualified name of the module or alias that is referenced by this alias; the null value otherwise.
CREATE_TIME TIMESTAMP   Time at which the module was created.
REMARKS VARCHAR (254) Y User-provided comments, or the null value.