Take the 2-minute tour ×  I'm trying to script the changes to a
SQL Server Compact Edition database running on windows mobile 6
and could really use:  EXECUTE sp_rename 'MyTable.SomeColumn',
'BrandNewName', 'COLUMN'  What other system stored procedures
are available?  What are the differences to the non compact
version?  Edit: There ARE system stored procedures in ce,
sp_rename is an example although it only seems to work against
tables not columns.  share|improve this question add comment  2
Answers  up vote 2 down vote accepted  I don't believe there are
any stored procedures available in SqlCe. My solution has been
to create a class that contains a SqlCeEngine and expose my own
methods like RenameColumn, and do the work internally.  EDIT 1:
Now, that's very interesting (the existence of sp_rename).
Considering the documentation out there that states there are no
stored procedures in SQL CE, I don't think it's really fair to
downvote anyone for that assumption.  EDIT 2: I've come across
this link from MSDN