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 ?
Solved! Go to Solution.
Views
Replies
Total Likes
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
Views
Replies
Total Likes
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
Views
Replies
Total Likes
Hi @tusharvats,
Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.
Thanks!
Views
Replies
Total Likes