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.