title: Drop column and all dependent objects using data definition language
body: <p>I need to remove a column from a table, but when I try to remove it:</p>
  
  <blockquote>
    <p>The object 'object_name' is dependent
    on column 'column_name'.</p>
    
    <p>ALTER TABLE DROP COLUMN column_name failed because
    one or more objects access this
    column.</p>
  </blockquote>
  
  <p>I can look for the dependency in the system tables and remove it manually, but I need to do a migration (using SQL <a href="http://en.wikipedia.org/wiki/Data_Definition_Language" rel="nofollow">DDL</a>) so all others members of the team just do the update, run the migration and don´t have to mess up up system objects.</p>