添加列的方式与在其他版本的 SQL Server 中添加列的方式相同:

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

这将一个名为 IdColumnName 的主键标识列添加到表 tableName:

This adds a primary key identity column called IdColumnName to the table tableName:

ALTER TABLE tableName
ADD COLUMN IdColumnName INTEGER IDENTITY (1,1) PRIMARY KEY

请参阅ALTER TABLE 语法适用于 SQL Server 精简版.

See the ALTER TABLE syntax for SQL Server compact edition.