title: SybaseDB , change the default value of an existing column in a table
body: <p>I have a table called "downloads" with a few thousand rows. I just added a column called is_completed using the following command:</p>
  
  <p><code>ALTER TABLE downloads ADD is_completed BIT default 1 NOT NULL</code> </p>
  
  <p>Now I would like to change the default value for is_completed to 0 - I tried this command to no avail:</p>
  
  <pre><code>ALTER TABLE downloads MODIFY is_completed default 0
  </code></pre>
  
  <p>This does not work, it says I have incorrect syntax near default. I can't seem to google this for the life of me. Anyone know the correct syntax? I want all future rows added to this table to have is_completed default to 0 if an explicit value is omitted. </p>