SYSCAT.NAMEMAPPINGS catalog view
Each row represents the mapping between a "logical" object (typed table or view and its columns and indexes, including inherited columns) and the corresponding "implementation" object (hierarchy table or hierarchy view and its columns and indexes) that implements the logical object.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TYPE | CHAR (1) |
|
|
LOGICAL_SCHEMA | VARCHAR (128) | Schema name of the logical object. | |
LOGICAL_NAME | VARCHAR (128) | Unqualified name of the logical object. | |
LOGICAL_COLNAME | VARCHAR (128) | Y | Name of the logical column if TYPE = 'C'; null value otherwise. |
IMPL_SCHEMA | VARCHAR (128) | Schema name of the implementation object that implements the logical object. | |
IMPL_NAME | VARCHAR (128) | Unqualified name of the implementation object that implements the logical object. | |
IMPL_COLNAME | VARCHAR (128) | Y | Name of the implementation column if TYPE = 'C'; null value otherwise. |