Share via


Data Type Considerations for Change Data Capture

All base column types are supported by change data capture. The following table lists the behavior and limitations for several column types:

Type of Column

Changes Captured in Change Tables

Limitations

Sparse Columns

Yes

Does not support capturing changes when using a columnset.

Computed Columns

No

Changes to computed columns are not tracked. The column will appear in the change table with the appropriate type, but will have a value of NULL.

XML

Yes

Changes to individual XML elements are not tracked.

Timestamp

Yes

The data type in the change table is converted to binary.

BLOB data types

Yes

The previous image of the BLOB column is stored only if the column itself is changed.