SQL Reference

SYSCAT.NAMEMAPPINGS

Each row represents the mapping between logical objects and the corresponding implementation objects that implement the logical objects.

Table 70. SYSCAT.NAMEMAPPINGS Catalog View

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