sp_rename '[OldTableName]','[NewTableName]'

查看以下链接以获取更多信息@H_502_4@

http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/@H_502_4@

http://erikej.blogspot.com/2007/08/hidden-gem-rename-table.html@H_502_4@

祝好运！@H_502_4@

UPDATE@H_502_4@

在这里你可以找到一个类似的问题@H_502_4@

How do I rename a table in SQL Server Compact Edition?@H_502_4@

你可以试试这个工具@H_502_4@

http://www.primeworks-mobile.com/@H_502_4@

或者在visual studio中试试这个@H_502_4@

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