Each row represents the mapping between logical objects and the corresponding implementation objects that implement the logical objects.
Table 66. SYSCAT.NAMEMAPPINGS Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| TYPE | CHAR(1) |
|
|
| LOGICAL_SCHEMA | VARCHAR(128) |
| Qualified name of the logical object. |
| LOGICAL_NAME | VARCHAR(128) |
| |
| LOGICAL_COLNAME | VARCHAR(128) | Yes | If TYPE = C, then the name of the logical column. Otherwise null. |
| IMPL_SCHEMA | VARCHAR(128) |
| Qualified name of the implementation object that implements the logical object. |
| IMPL_NAME | VARCHAR(128) |
| |
| IMPL_COLNAME | VARCHAR(128) | Yes | If TYPE = C, then the name of the implementation column. Otherwise null. |