将列插入表中时出错

I am using the PUBS database of microsoft in c# programming language I am using Micosoft SQL server Management Studio too.

我在c#编程语言中使用微软的PUBS数据库我也在使用Micosoft SQL服务器管理工​​作室。

In this there is a table. When I am trying to insert a record into any table and save this table the error message will give like this

在这里有一张桌子。当我尝试将记录插入任何表并保存此表时,错误消息将给出这样的结果

Save Changes is not Permitted this changes to be required the following table to be dropped and re-create you have either made changes to the table that's cant be created and enabled the option prevent saving changes that required to be recreated **

保存更改不被允许此更改需要删除以下表并重新创建您已对表创建的表进行更改并启用该选项以防止保存需要重新创建的更改**

So what is the problem?

那么问题是什么?

2 个解决方案

#1

It's a configurable option to prevent users from running commands that they think will be simple ALTER statements, but actually require the whole table and its data to be DROP and CREATE again:

它是一个可配置的选项,可以防止用户运行他们认为是简单的ALTER语句的命令,但实际上需要整个表及其数据再次进行DROP和CREATE:

Tools > Options

Designers > Table and Database Designers

Uncheck "Prevent saving changes that require table re-creation"

#2

It is settings that is made under the option of Database designer section to prevent DDL operation. Disable the option prevent saving changes that required to be recreated in your SQL Server option.

它是在数据库设计器部分选项下进行的设置,以防止DDL操作。禁用该选项可防止保存需要在SQL Server选项中重新创建的更改。

You will find this under tools menu > Option > Designer > Uncheck the checkbox prevent saving changes that require table re-creation.

您可以在工具菜单>选项>设计器>取消选中该复选框,以防止保存需要重新创建表的更改。

In Visual Studio tools menu > Option > Database Tools > Table and Database Designer > Uncheck the check box prevent saving changes that require table re-creation.

在Visual Studio工具菜单>选项>数据库工具>表和数据库设计器>取消选中该复选框可防止保存需要重新创建表的更改。

Hope this help

希望这有帮助