Merging columns


To merge columns, they must be compatible. Thus, column merges are possible when you have these combinations:
Mechanism

The columns are merged but the columns’ properties are not, therefore the target columns’ properties are kept. Also, any links on the source object will be transferred to the target object, e.g. if the column is part of an index, the target column will become the new index column. And for this reason, it is only possible to unmerge foreign-foreign type of merger.


Usage

The Merge function is mainly used to duplicate foreign key columns and recreate a key structure with existing information.