title: SQL Server 2000 drop column with constraints
body: <p>I have the same problem as described in <a href="https://stackoverflow.com/questions/314998/sql-server-2005-drop-column-with-constraints">this question</a>, but there it's SQL Server 2005 and the "accepted" answer doesn't work in SQL Server 2000.</p>
  
  <p>Specifically: I'm trying to run <code>ALTER TABLE foo DROP COLUMN bar</code>, and it's failing because there's a "default constraint."  Meaning, I have a default value on that column which SQL Server implements as a separate constraint that I need to delete first.</p>
  
  <p>The problem is no name was given for the default constraint when the column was created, so I have to query the system tables to discover the (auto-generated) name of the constraint.</p>
  
  <p>The answer given in that other question works for me in SQL Server 2005 but not in SQL Server 2000.  I need the latter.</p>
  
  <p>[UPDATE]  I need a <em>query</em> that can answer the question "What is the name of the default constraint for column <code>bar</code> in table <code>foo</code>."  Not a way for a human being to manually find the answer.</p>