Bernhard S
Member³
When you compare two tables with the source having some columns less than target and a multi-column index that on the target site includes those columns together with some more that exist on both sides, the resulting difference consists of the following:
1. drop column statements
2. drop multi-column index statement
3. create multi-column index statement with remaining columns
However when applying those changes to the target site, the 2nd statement will fail, because the drop of the columns already dropped the muli-column-index as well.
The resulting table is identical with the source though, just the error should be avoided.
1. drop column statements
2. drop multi-column index statement
3. create multi-column index statement with remaining columns
However when applying those changes to the target site, the 2nd statement will fail, because the drop of the columns already dropped the muli-column-index as well.
The resulting table is identical with the source though, just the error should be avoided.
