replication(数据复制)中CCD目标表的属性参数-complete, condensed

博客主要介绍了SQL复制中一致变更数据（CCD）表，它可用于存储历史、审计或暂存数据，也能作为复制源。还详细阐述了完整CCD表、非完整CCD表、压缩CCD表和非压缩CCD表的定义及特点，对比了不同类型表的差异。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

consistent-change data (CCD) table. In SQL replication, a type of replication target table that is used for storing history, for auditing data, or for staging data. A CCD table can also be a replication source. See also complete CCD table, condensed CCD table, external CCD table, internal CCD table, noncomplete CCD table, and noncondensed CCD table.

complete CCD table. In SQL replication, a CCD table that initially contains all the rows from the replication source table or view and any predicates from the source table or view. Contrast with noncomplete CCD table. See also consistent-change data (CCD) table.

noncomplete CCD table. In SQL replication, a CCD table that is initially empty and has rows appended to it as changes are made to the replication source. Contrast with complete CCD table. See also consistent-change data (CCD) table.

condensed. In SQL replication, a table attribute that indicates that the table contains current data rather than a history of changes to the data. A condensed table includes no more than one row for each primary key value in the table. As a result, a condensed table can be used to supply current information for a refresh.

condensed CCD table. In SQL replication, a CCD table that contains only the most current value for a row and has only one row for each key value. Contrast with noncondensed CCD table. See also consistent-change data (CCD) table.

noncondensed CCD table. In SQL replication, a CCD table that can contain more than one row for each key value. These duplicate rows represent the history of changes for the values in rows of a table. Contrast with condensed CCD table. See also consistent-change data (CCD) table.