sql server ce - How can I add a column to an existing table? -

How can I change a table in SQL Server Compact Edition (SQL CE)?

I have an existing table, and add me a identity / <> code

You can add a column in the same way you will add it to other versions of SQL Server:

This is a primary key for the ID card IDColumnName named column TableName :

  Add an optional table table of contents column ID columnName identifier identifier (1,1) Primary key  

SQL Server Compact Sons See Syntax for Karan.