title: Alter column's default value
body: <p>I  have a table which has a column 'CompanyID int not null' and its default value is set to 10. Now I want to write a query which will alter this default value to 1. How can can I do it?</p>
  
  <p>Any help will be appreciated. I am using SQL server 2000.</p>