title: What's the best way to rename a column referenced in a computed column?
body: <p>I'm trying to rename a column using <code>sp_rename</code> but it's referenced in a computed column. I'm getting the following error:</p>
  
  <blockquote>
    <p>'Table.Column' cannot be renamed because the object participates in enforced dependencies.</p>
  </blockquote>
  
  <p>As far as I can tell the (persisted) computed column is the only place this is referenced. I guess I can drop and recreate the computed column since I won't technically be losing any data, but I wondered if there was a cleaner way?</p>
  
  <p>Thanks</p>
  
  <p>Phil</p>