title: How to modify datatype of a column with a default value
body: <p>I'm trying to change the datatype of a column in SQL Server from tinyint to smallint.</p>
  
  <p>But there's a default value on my column and I don't know the name of the constraint.</p>
  
  <p>Is there an easy way to do it ?</p>
  
  <p>This don't work because of the default constraint : </p>
  
  <pre><code>ALTER TABLE mytable
  Alter Column myColumn smallint NOT NULL default 1
  </code></pre>