title: How to drop column with constraint?
body: <p>How to drop a column which is having Default constraint in SQL Server 2008?</p>
  
  <p>My query is </p>
  
  <pre><code>alter table tbloffers
  drop column checkin
  </code></pre>
  
  <p>I am getting below error</p>
  
  <blockquote>
    <p>ALTER TABLE DROP COLUMN checkin failed because one or more objects access this column.</p>
  </blockquote>
  
  <p>Can anyone correct my query to drop a column with constraint?</p>