title: How can I remove JSON property stored in a SQL Server column?
body: <p>I have a task to remove a JSON property saved in a SQL Server database table's column. Here is the structure of my table </p>
  
  <pre><code>OrderId   Name   JSON
  </code></pre>
  
  <p>In the <code>JSON</code> column I have this JSON data:</p>
  
  <pre><code>{ 
      "Property1" :"",
      "Property2" :"",
      "metadata-department": "A",
      "metadata-group": "B"
  }
  </code></pre>
  
  <p>I have over 500 records that have this json value. </p>
  
  <p>Can I update all the records to remove <code>metadata-department</code>?</p>