SQL 2008中不允许保存更改 [英] Saving Changes is not permitted in SQL 2008

问题描述

我正在尝试在表格中添加新列。有一个错误来了。我对数据库很新，我完全没能弄清楚问题出现的原因.......



不允许保存更改。您所做的更改需要删除并重新创建下表...

i'm trying to add a new column in a table . there is an error coming. i'm very new to Database and i'm totally failed to figure out why the problem is being occur.....!

" Saving changes is not permitted. the changes you've made require the following tablesto be dropped and re-created... "

推荐答案

当您尝试使用表设计器时会发生此错误处理更改 - 它是一个无法处理SQL允许你做的所有事情的工具...

所以你需要做的是通过一些DDL（数据定义语言）查询来做到这一点。 。在你的情况下：

This error occurs when you try to use the table-designer to handle changes - it is a tool that can't handle everything SQL allows you to do...
So what you have to do is do it by some DDL (Data Definition Language) query...in you case:

ALTER TABLE myTable ADD COLUMN newColum INT NULL

ALTER TABLE帮助页面...... [ ^ ]

啊......



这个老栗子再次抬头......



在SQL Manager中，从菜单栏中选择



工具 - >选项



导航至



设计师

桌子和数据库设计师



取消选中该项目



预防保存需要表重新创建的更改



全部完成...

Ahhh...

This old chestnut rears its head once again...

In SQL Manager, select from the menu bar

Tools -> Options

Navigate down to

Designers
Table and Database Designers

Uncheck the item

"Prevent Saving Changes That Require Table Recreation"

All done...

这篇关于SQL 2008中不允许保存更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！