I'm new to SQL Server Compact edition. I'm using Compact edition 3.5. I tried renaming the table. But, I couldn't do that through the following query.
alter table tablename to newname
Plz, someone help me.........
Try this
sp_rename '[OldTableName]' , '[NewTableName]'
Check links below for more information
http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/
http://erikej.blogspot.com/2007/08/hidden-gem-rename-table.html
Good Luck!
UPDATE
Here you can find a similar question
How do I rename a table in SQL Server Compact Edition?
You can try this tool
http://www.primeworks-mobile.com/
or try this in visual studio
conn.Open();
SqlCeCommand cmd = new SqlCeCommand("sp_rename 'oldTable', 'newTable' ", conn);
cmd.ExecuteNonQuery();
conn.Close();
In Visual Studio:
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With