[SalesForce] Marketing Cloud – Adding additional Primary Keys to a Existing Data Extension

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

Best Answer

If the DE has data in it you cannot add a primary key. Once you clear the data you can delete the field you want to add the primary key, then re-add it and select it as a primarykey. You could also copy the DE and then set the primary key then use a query activity to populate the new DE if you need to save the data

Related Topic