title: Adding default constraint to column
body: <p>I have added a default constraint to column(department_id), and then deleted it, after that again I try to add default constraint to same column, I could not understand why am I getting this error after deleting that, could any one help me, I am new to sql...</p>
  
  <p>Error is:</p>
  
  <blockquote>
    <p>Msg 1781, Level 16, State 1, Line 1 Column already has a DEFAULT bound
    to it. Msg 1750, Level 16, State 0, Line 1 Could not create
    constraint. See previous errors.</p>
  </blockquote>