Each row represents a module.
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:
|
|
OWNER | VARCHAR (128) | Authorization ID of the owner of the module. | |
OWNERTYPE | CHAR (1) |
|
|
MODULETYPE | CHAR (1) | Type of module.
|
|
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. |