Answers.Body: <p>Pretty sure you can truncate the civicrm_value_customname table. I've done that before with no ill effects (assuming you don't have custom code running off those values).</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-08T13:21:10.290Z
Answers.Text: Thanx a load! I'll try tonight.
Answers.UserDisplayName: nielo
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-08T12:13:20.193Z
Answers.LastActivityDate: 2015-12-08T12:13:20.193Z
Answers.UserDisplayName: Andrew West
Answers.Body: <p>Why do you need that?</p>
  
  <p>Do you want to keep the fields, but only empty?</p>
  
  <p>Deleting the fields would make the most sense to me. That can be done via the web interface.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-08T10:07:57.977Z
Answers.Text: No, I want to clear the fields. Sorry if I failed to point that one out. But in this case (multiple records) I think my wording is better than saying "clear" because the db rows have to be deleted.
Answers.UserDisplayName: nielo
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-12-08T09:52:13.623Z
Answers.LastActivityDate: 2015-12-08T09:52:13.623Z
Answers.UserDisplayName: Catorghans
Body: <p>My goal is to free all contacts of a specific custom fields group. In other words I want to clear all occurrences of a multiple records custom field set. May I truncate the <code>civicrm_value_&lt;customfieldsetname&gt;&lt;id&gt;</code> table, is there an api method or how can I safely achieve this?  </p>
  
  <p>Thanks in advance // nielo</p>
  
Tags: <custom-fields>
Title: Clear custom multiple records fieldset occurences
ThreadText: # Clear custom multiple records fieldset occurences
  
  (Asked by: username_0 on 2015-12-07)
  
  My goal is to free all contacts of a specific custom fields group. In other words I want to clear all occurrences of a multiple records custom field set. May I truncate the `civicrm_value_` table, is there an api method or how can I safely achieve this?
  
  Thanks in advance // username_0
  
  **Tags:** custom-fields
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2015-12-08. Score: 2 | Accepted answer
  
  Pretty sure you can truncate the civicrm\_value\_customname table. I've done that before with no ill effects (assuming you don't have custom code running off those values).
  
  > **Comments:**
  > **username_0**: Thanx a load! I'll try tonight.  
  
  ---
  
  ### Answer by username_2 on 2015-12-08. Score: 0
  
  Why do you need that?
  
  Do you want to keep the fields, but only empty?
  
  Deleting the fields would make the most sense to me. That can be done via the web interface.
  
  > **Comments:**
  > **username_0**: No, I want to clear the fields. Sorry if I failed to point that one out. But in this case (multiple records) I think my wording is better than saying "clear" because the db rows have to be deleted.  
  
  ---
  
  