Should it be possible to update an existing data extension to add additional primary keys?
We have a current Data Extension that has a primary key as subscriber key however noticed that a person can be in the data more than once but unique based on store ID so wanted to update the data extension to add a second primary key on store location. I could have sworn i was able to do this in the past.
Is this a permission issue or is it not possible once the data extension has been created?
I can see if i add an additional field, i can add that as the primary key, just wont let me update an exciting field