Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Updating primary key data type in Adobe Campaign

Avatar

Level 1

Hi All,

We are trying to update the data type of primary key from int to text for one of the custom schemas in AC. However, does this mean do we need to truncate the table to process this through or can we retain the data ?

1 Accepted Solution

Avatar

Correct answer by
Level 2

Hi! We recently had to change the ID in all tables on our instance. Our approach was to create a new string type column and add the values there. After that we could change all the joins to that new data field, and lastly truncate only the "old" column

View solution in original post

2 Replies

Avatar

Correct answer by
Level 2

Hi! We recently had to change the ID in all tables on our instance. Our approach was to create a new string type column and add the values there. After that we could change all the joins to that new data field, and lastly truncate only the "old" column

Avatar

Administrator

Hi @tusharvats,

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!