
ppyrzynski asked a question.
Is there a way to rename a custom property after it has been added?
I have a custom field on a custom tab added to application object. The internal name that was given to that field pretty much matches the DisplayName.
Now we decided to use that field for different purpose and the DisplayName is going to be totally different. To avoid confusion in case any new custom fields are added in the future, I'd like change the internal name to match new display name.
Any thoughts?
Yes, you can update the internal name of a custom property. You can do so by updating the internal field name in three different tables in the [FNMSCompliance] database:
The following SQL code can be used as a template:
UPDATE [UIItem] SET
ItemResourceName = '<NewFieldName>'
WHERE
ItemResourceName = '<OldFieldName>'
UPDATE [ResourceStringCultureType] SET
ResourceString = '<NewFieldName>'
WHERE
ResourceString = '<OldFieldName>'
UPDATE [AssetTypeProperty] SET
PropertyName = '<NewFieldName>'
WHERE
PropertyName = '<OldFieldName>'
Thanks a lot, man!