How to create a column in SQL Server Compact Edition using SQL Server Management Studio (2008)

Question

I am trying to create an SQL Server Compact edition in SQL Server Management Studio 2008. I created the database and one table it. I also created one column in the table (using visual tools in SQL Server Management Studio) but I cannot create any other column.

Is there any possibility to create a column without using SQL commands (I can do this when I am working with a SQL Server database, by right clicking on the table and selecting design, but isn't this option available for SQL Server Compact?)

Answer 1

Right click the table select Edit Table, add the new column at the bottom of the column list.

Answer 2

I uninstalled everything and reinstalled the latest version and now I can do this! Probably the versions were not correct or there was a problem with installation.