MS SQL2012修改数据表字段排序

当在SQL2012中修改表中字段的顺序，保存时提示：

Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created.

更改设置：

1、Open SQL Server 2008 Management Studio (SSMS)

2、Click Tools menu and then click on Options

3、Expand Designers node and select Table and Database Designers option

4、You need to uncheck “Prevent saving changes that require the table re-creation” option and click OK to save changes

 

以上 “Prevent saving changes that require the table re-creation” option是默认勾选的，在修改保存数据表后最好将该项勾选。

另外，在Insert数据表时最好将字段名写上，这样就避免因为顺序的调整，要修改代码

 

以上内容参考 http://www.sql-server-performance.com/2009/saving-changes-not-permitted/

仅作学习用途

转载于:https://www.cnblogs.com/wftrustself/p/3309128.html