更新列定义问题 [英] Update Column Defination issue

问题描述

我是SQL 2010，每当我尝试更新表系统的现有列定义（即更改数据类型，分配外键）时，都会抛出错误不允许保存更改。您所做的更改需要以下内容

要删除和重新创建的表。您已经对表进行了更改

无法重新创建或启用选项防止保存需要

要重新创建的表。



表中没有值。有什么设置吗？

I am SQL 2010, Whenever I am trying to update existing column definition(i.e change datatype, assign foreign key) of a table system throws an error"Saving changes is not permitted. The changes you have made require the following
Tables to be dropped and re-created. You have either made changes to a table that
Can’t be re-created or enabled the option Prevent saving changes that require the
Table to be re-created."

There is no value in table. Is there is any setting to do?

推荐答案

为什么你没有用google搜索该错误信息？



要更改此选项，请在工具菜单上单击选项，展开设计器，然后单击表和数据库设计器。清除阻止保存需要重新创建表的更改复选框。



粘贴自在其中 [ ^ ]

Why haven't you googled that error message ?

To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. Clear the Prevent saving changes that require the table to be re-created check box.

Pasted from here[^]

这篇关于更新列定义问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！