How do I rename a table in SQL Server Compact Edition?
Not sure about doing it via VS2008, but you can use sp_rename
: Changes the name of a user table in the current database. Currently, sp_rename support in SQL Server Compact 3.5 is limited to tables.
sp_rename [ @objname = ] 'object_name', [ @newname = ] 'new_name' [ , [ @objtype = ] 'object_type' ]
To rename the table oldtable to newtable:
sp_rename 'oldtablename', 'newtablename';