MergeColumnUsage Enumeration
MergeColumnUsage Enumeration
The MergeColumnUsage enumeration provides options for how the specified column will be merged from the source table to the target table.
Enumeration Values
| Name | Summary |
|---|---|
| Compare | Specifies that the column will only be used in comparing rows for a merge match. |
| Update | Specifies that the column will only be used to update target table values when a row matches. |
| Insert | Specifies that the column will only be used to insert new target table values when a row does not match. |
| CompareUpdate | Specifies that a column with both compare and update but not insert. |
| CompareInsert | Specifies that a column with both compare and insert but not update. |
| UpdateInsert | Specifies that a column with both update and insert but not compare. |
| CompareUpdateInsert | Specifies that a column with compare, update, and insert. |
| Exclude | Specifies that the column will be excluded entirely from the merge operation. |