When altering an index, the script that is created is missing some of the components is should have.
The First Problem is that the script does not first DROP the Index Before trying to Create the index with the new column in it.
The second problem is that the Constraint that is going to be built does not have the new column in it.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center