title: Microsoft SQL Compact Edition rename column
body: <p>I am having problems renaming a column in SQL Server Compact Edition. I know that you can rename a table using <code>sp_rename</code>, but this doesn't work with columns.</p>
  
  <p>I've searched for an alternative, but haven't found one. </p>
  
  <p>Can I delete a column and then add a new one after a specific column? If I delete the column and add it after the a specified one the data would be lost right?</p>
  
  <p>It seems that once you have created the table it can't be properly modified - is this another of the limitations of SQLCE?</p>