Stack Exchange Network
Stack Exchange network consists of 181 Q&A communities including
Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
Anybody can ask a question
The best answers are voted up and rise to the top
3 years, 9 months ago
I just realized that the datatype of the
PK column of my data extension should be of type
Text instead of Number (otherwise I can not link it to the
The data extension is rather big with about one hundred columns and already populated. I tried duplicating it to be able to remove the PK column and then re-uploading the data into it. But the column does not seem to go away simply by manually deleting it.
How can I change the type of the PK column without manually recreating the data extension?
Jun 11, 2019 at 13:52
610 6 6 silver badges 24 24 bronze badges
Your best bet is to do a 'Create from Existing' and choose the current DE.
This will prefill the field editing section with the existing fields/data types/etc. from your origianl DE.
You can then change your data type from number to text and then 'create'. From there you just import in the data into this new DE and you are good to go.
There really is no way to edit an existing DE's primary key, so recreating is the only way to do it.
Jun 11, 2019 at 14:11
29.7k 3 3 gold badges 23 23 silver badges 59 59 bronze badges
It's kind of surprising that different parts of Marketing Cloud have a different way of doing things, so it will be important to follow the instructions mentioned here:
Email Studio > Subscribers > Data extensions
You should see a list of data extensions with the left panel showing the folder tree (if not hidden) and the blue
Create button in the top right corner
In the window select
Standard Data Extension and click
OK. In the
first step called
Create from Existing in the
Creation Method dropdown.
Proceed to the 3rd step called
configure the fields as you please (including changing the data
type, primary keys and nullable settings).
Jun 11, 2019 at 14:12
By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our
Accept all cookies
Necessary cookies only