Because of Compact Edition's limited features, to rename a
column you need to create a new column with the desired name, copy any data
from the old column to the new, and finally delete the old column. The example
below renames an integer column in SQLCE.
Jimmy
[code:vb]
ALTER TABLE MyTable ADD NewColumnName INTEGER
UPDATE MyTable SET NewColumnName = OldColumnName
ALTER TABLE MyTable DROP COLUMN OldColumnName[/code]