MAPSCHEMANAMES

Definition

System table MAPSCHEMANAMES contains information about the schema maps that the Loader can use.

When a schema map is created, the corresponding entries are inserted into the MAPSCHEMANAMES system table. If you delete a schema map, the corresponding entries are deleted from this system table.

See also:

CREATE/DROP SCHEMAMAP Statement

USE SCHEMAMAP Command

Structure

MAPSCHEMANAMES

PACKAGEGUID

CHAR(24) BYTE

Unique ID of the schema map

MAPPINGNAME

CHAR(32)

Name of the schema map

SOURCESCHEMANAME

CHAR(32)

Name of the schema that is mapped to the target schema

TARGETSCHEMANAME

CHAR(32)

Name of the schema that the original schema is mapped onto

See also:

IMPORT SCHEMA Command