如何在SQL Server Compact Edition中重命名表
技术问答
234 人阅读
|
0 人回复
|
2023-09-13
|
|
我是SQL Server Compact新手版本。我在用它。Compact Edition 3.5.我试图重命名表。但是，我不能通过以下查询来做到这一点。2 Z% h& f4 Q2 ?: i" l0 a
将表tablename更改为newname
! l [: O9 a5 G# X% q4 O+ LPlz，有人帮我........., V) L7 m' B! q. T' ~* Y- K
/ w: y5 i# a: }4 ?0 y: `. x
解决方案: 7 L) P! K$ t$ |! X$ r# N. W& c
试试这个
( V9 { x6 o* G6 ~; V9 Z: J% Xsp_rename '[OldTableName]' ,'[NewTableName]'祝你好运！9 v6 O: t/ z) J
更新+ O8 y/ W" L; m% a" u1 {5 A
您可以尝试此工具
6 {7 W$ i3 c M9 z, k$ `http://www.primeworks-mobile.com/; H0 o8 u$ A1 E, M
或在Visual Studio中尝试
! f% j% }5 G6 s: y1 w3 _4 vconn.Open();SqlCeCommand cmd = new SqlCeCommand("sp_rename 'oldTable','newTable' ",conn);cmd.ExecuteNonQuery();conn.Close()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；； |
|
|
|
|
|
|
|
|
|
