SQL Server 修改数据库字段类型,提示需要删除表或者重新建表

SQL Server 修改数据库字段类型,提示需要删除表或者重新建表,提示错误信息如下:

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

打开SQL Server Management Studio –> 选择工具Tools –>选项options –> Designers -> Disable “Prevent saving changes that require the table re-creation” ,把前面的勾去掉,重新保存就OK了。