Adding default constraint to column
<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>