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.