CiviCRM Community Forums (archive)

When you create a custom field, the field label you use ends up being the column name (well plus some, to me, pointless number) in the table in the db.   I stupidly didn't realize this until I had created a bunch of ones with really long labels that ended up being really long column names - a real pain if one is writing sql directly against the db.

If you go back and change the field label after you have created it doesn't alter the column name.  Question, what does it take to change the column name?  If I change the column name in the database custom table and then change it in the civicrm_custom_fields is that all I need to do.

Similarly, if I want to change the custom table name, do I just need to change the table name in the db and the name in civicrm_custom_group?

Thanks

Similarly, if I want to change the custom table name, do I just need to change the table name in the db and the name in civicrm_custom_group?

Yes, that should work.