How to rename a table in the sql server compact edition -


I am new to the compact version of SQL Server. I'm using compact version 3.5. I tried to rename the table but, I could not do this through the following questions.

Changing table tableName for new name

PLJ, someone helps me ...... ...

< / Div>

try it

  sp_rename '[OldTableName]', '[newtname]'     UPDATE   

Here you can get a similar question

You can try this tool

or try it in Visual Studio

  conn.Open (); SqlCeCommand cmd = New SqlCeCommand ("sp_rename 'oldTable', 'newTable' ', conn); cmd.ExecuteNonQuery (); conn.Close ();  

Comments