title: How to change the column order in a SQL Server Compact Edition table schema?
body: <p>I'm using Visual Studio 2008 to design a <strong>SQL Server Compact Edition</strong> database (*.sdf). I had to change the schema of one of my tables adding a new column. </p>
  
  <p>I want to <strong>"move" that new column</strong> from the bottom to a different position in the field list. How can I do this in the Visual Studio designer?</p>
  
  <p><em>EDIT: I know that from a pure technical view point the order of the columns doesn't matter. I'm prototyping an application, so I have to change the schema a couple of times. If, for example I have to change the primary key, it would be "ugly" having the most important column at the end. Other developers looking at the code would be confused, I think. It's a matter of esthetics.</em></p>