TAN WhoAMI

TAN WhoAMI

  • NA
  • 291
  • 0

SQL CE 4.0 Database in Visual Studio 2010 Server Explorer

Mar 13 2013 8:48 PM
I manage to get SQL CE 4.0 Database in Visual Studio 2010, and see it in the Server Explorer.
However, I see one difference between the SQL Server Database and SQL CE 4.0 Database in the Server Explorer.

With the SQL Server Database, I am able to go to its individual Tables, and Open Table Definition, and Insert Column/Delete Column. This allows Insert Column in between any existing columns.

With the SQL CE 4.0 Database, I do not see the Open Table Definition option. The only option I can choose is: Edit Table Schema. Inside Edit Table, I can only Insert new Column as the last Column, and I cannot insert column in between those existing columns. Why? The only workaround is to delete those existing columns, insert the new column, and insert back those deleted columns, which is very troublesome.

Say I have Columns A, B, C, D, and I want to insert Column A1, after Column A. I need to remove Columns B,C, and D and insert Column A1, then insert Columns B,C and D again.

Did anyone face the same problems? What are the better solutions?