title: How can I DROP COLUMN in Microsoft SQL Server with a value?
body: <p>Code:</p>
  
  <pre><code>ALTER TABLE tblUser
  DROP COLUMN Mobile
  </code></pre>
  
  <p>Error:</p>
  
  <blockquote>
    <p>ALTER TABLE DROP COLUMN Mobile failed because one or more objects access this column.  </p>
  </blockquote>
  
  <p>This column had values in Table. How can I delete all objects that access this column?</p>
  
  <p>How can I <code>DROP COLUMN</code> with values?</p>
  
  <p>how can do it with code? How can I delete all constraints in column automatically?</p>