Is it safe to clear down the SysProfileData table?

Is it safe/supported to delete all data in the SysProfileData table where the ContactId is populated?


We want to deploy default column setups across the board into environments where users may have set them up, which isn't possible without removing their custom column setups from this table. The simplest way I can think to do this would be to delete all SysProfileData records where ContactId is populated (i.e. they are user customisations) but wanted to check this would be safe.

Like 0



Dear Harvey, 

Theoretically, it's possible. 
However, we recommend you to contact Creatio support team and request a DB backup of your website if it's deployed in cloud and carefully test it on the copy of the website before making any changes to actual production. 

Kind regards,

Hi Roman, is there a better/recommended way to reset all users' column bindings back to the defaults in an environment?  Also, what are the risks involved around doing this? I understand that users' applied filters for each Section are also stored in this table - what other data is stored there which could cause a problem if it were deleted?



Show all comments