Replica table

The replica table must have the same key columns as the source table. Because of these similarities, the replica table can be used as a source table for other subscription sets. Converting a target table into a source table is done automatically when you define a replica target type and specify the CHANGE DATA CAPTURE attribute.

schema.replica

Server: target server

This table contains information that you can update by using SQL.

Table 1 provides a brief description of the columns in the replica table.

Table 1. Columns in the replica table
Column name	Description
user key columns	The columns that make up the target key, which must be the same primary key as the primary table.
user nonkey columns	The nonkey data columns from the source table. The column names in this target table do not need to match the column names in the source table, but the data types must match.