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.

Table 1. SYSCAT.NAMEMAPPINGS Catalog View
Column Name Data Type Nullable Description
TYPE CHAR (1)  
  • C = Column
  • I = Index
  • U = Typed table
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.