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. |