Updating existing PK in the table

[RajatPanwar]

If there is a custom schema with composite PK. Is it recommended to change the composite PK and remove columns from previous PK and add new columns?

Will this change result in corruption of existing campaign workflows using the schema? Any other issues and if there is a recommendation on dealing with this type of change?

Thanks. 

[LakshmiPravallika · Accepted solution]

Hi @RajatPanwar ,

The change of a column in the Primary Composite key will not corrupt the columns not the data in the Schema.

In the downstream Campaigns, in any logic if you are using the Reconciliation Keys in Enrichment to Join or Using Update Data activity these keys should be changes accordingly as per the Unique Primary key combination, so that it won't be impacting the Campaigns.

Regards,

Pravallika.

[RajatPanwar]

Thanks. if the new composite PK have records in the schema which are not unique based on the combination, will the schema/other screens in the console through an error and we need to clean up those rows and make it unique based on the new composite PK?

[LakshmiPravallika]

Hi @RajatPanwar ,

Yes, if the previous data before changing composite key is not unique as per latest Composite key, either u can update the newly added primary key column to get the Unique key combination or delete the data.

Regards,

Pravallika