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
...
[More]