If you delete a custom profile field, it will delete the field on any record that is housing it.