Hey everyone,
I would like to ask if someone here experienced an issue when creating UNIQUE CONSTRAINT and deploying it through SQL Change Automation.
The issue is SQL Change Automation does not follow the specified name in the deploy-once script. It only happens when creating UNIQUE CONSTRAINTS. We've tried creating an INDEX and the name is being assigned properly.
I would like to ask if someone here experienced an issue when creating UNIQUE CONSTRAINT and deploying it through SQL Change Automation.
The issue is SQL Change Automation does not follow the specified name in the deploy-once script. It only happens when creating UNIQUE CONSTRAINTS. We've tried creating an INDEX and the name is being assigned properly.