title: How to change column's type in SQL Server CE?
body: <p>I would like to change the type of a table's column in a SQL Server Compact Edition database, but it seems that the statement</p>
  
  <pre><code>ALTER TABLE [table name] modify [column name] [new type]
  </code></pre>
  
  <p>isn't working (VS2010 gave me the error : "The ALTER TABLE SQL construct or statement is not supported."). </p>
  
  <p>My original type is INT and I would like to change it to a BIGINT.</p>
  
  <p>Is it completely unsupported by SQL Server CE or do I have to execute another kind of query ?  </p>