Right now it is not a problem to delete it but I wanted to know what is the way to do it because I might need the same thing in another scenario. I also wanted to avoid creating a table *_cstm when creating a new field
Hi, the type of a custom field created in studio is saved in the table fields_meta_data
To convert the field it would be helpful if you create a new field with the type and desired configuration, as the fields “ext1”, "ext2, “ext3”, “ext4” contain specific configuration details depending in which field type you configure.
In case you want to create a custom field which contents is not saved in a _cstm table, but in the same table where the standard fields of the module are saved, then you’d have to set it up by creating a vardef file, which should probably be saved in (name of the file you can decide for yourself) public/legacy/custom/Extension/modules/sonar_sale/my_special_field.php
with contents something like in the following post (first file):
Please note you have to prepend public/legacy/ in the file paths for Suitecrm 8.
To get an idea what you need to define as vardefs, you can also create a module in ModuleBuilder with the field you want, then publish the module and analyze its contents