SQL2008修改表结构的时候弹出的提示. Saving changes is not permitted.

禁用表重建选项
最新推荐文章于 2024-02-27 10:57:15 发布
转载 最新推荐文章于 2024-02-27 10:57:15 发布 · 68 阅读 · 0 ·
CC 4.0 BY-SA版权
原文链接：http://www.cnblogs.com/xh831213/archive/2010/08/04/1791779.html

本文介绍了解决在尝试保存更改时遇到错误的方法，该错误提示不允许保存更改，因为所做的更改需要删除并重新创建表格。解决方案涉及取消选中“防止保存需要重新创建表格的更改”选项。
弹出如下信息.

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 re-created or enabled the option Prevent saving changes that require the table to be re-created

解决方法:

Tools->Options->Designers->Table options->Prevent saving changes that require the table re-creation

把这一项uncheck

转载于:https://www.cnblogs.com/xh831213/archive/2010/08/04/1791779.html

2023-02-08 InnoDB Architecture
悟世之路
02-08 383
InnoDB Architecture。
saving changes is not permitted.The changes you have made require the following tables to...
学者-微风
09-24 1140
修改数据库时，提示： saving changes is not permitted.The changes you have made require the following tables to be dropd 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 tabl
修改SQL Server 表时提示：Saving changes is not permissted .The changes you have made require the following ...
weixin_30426957的博客
07-08 307
问题： 修改数据库表的时候，无法选择保存，提示：saving changes is not permitted , 如下图1，如果选择cancle，就会撤销保存，如果选择Save Text File，就会保存一个TXT 文件，不过不是sql 脚本，个人觉得没用。 解决方法：不要捉急，这是因为你设置了保存修改时重建表（一般是默认的） 　　　　　1.回到SQL server首页。 　　　　　...
Saving changes is not permitted. （修改表时无法保存）
weixin_41579911的博客
06-16 818
弹出如下信息. 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 re-created or enabled t...
数据库：在修改表结构的时候提示不允许保存更改的解决方法
DaiDaiLiu的专栏
01-07 5658
在现有的数据表上对表增减一些字段，保存时提示：不允许保存更改。您所做的更改要求删除并重新创建以下表。您对无法重新创建的表进行了更改或者启用了“阻止保存要求重新创建表的更改”选项。           处理方法就是：选择菜单 工具-〉选项-〉左侧有个 设计器-〉表设计器和数据库设计器。然后去掉“ 阻止保存要求重新创建表的更改”前面的勾。重新启动MSSQL SERVER 2008即可。如截图。
MySQL运维DBA-MySQL8数据备份和恢复-006篇-mysqldump man帮助手册
老韩的Linux云计算架构师进阶之路
02-27 783
MySQL8数据备份和恢复-001-mysqldump man帮助手册。
Oracle Database 12c SQL Fundamentals I Exam Guide Exam 1Z0-061 学习笔记
tavor的专栏
07-13 3232
I. any arithmatic operator with null will result null   concate null will not result in null, will remain the same without nullII, for ' in literal value, could use '' to escape the it.    or could us
ocp-1Z0-082
qq_36369239的博客
05-04 4259
C、私有临时表和全局临时表都有ON COMMIT DELETE ROWS和ON COMMIT PRESERVE ROWS的两种分类(delete rows用于事务相关,也就在事务结束后truncate data in the temporary table,preserve rows表示在会话结束后清除临时表的数据)A、不可用索引会自动删除segment,但是索引分区后，某个分区的索引不可用，其它索引段还在的。B、私有临时表这个特性18C才引入。答案： B E F。答案： A B D。
RAC: Frequently Asked Questions [ID 220970.1]
11-22 1661
RAC: Frequently Asked Questions [ID 220970.1]Applies to: Oracle Server - Enterprise Edition - Version 9....
SQl 语句(常见) 新建,删除,修改表结构
01-05
SQl 语句(常见) 新建,删除,修改表结构
解决SqlServer2008修改表后保存时出现“save changes is not permitted…”问题
weixin_34413802的博客
06-08 279
在使用SQL Server 2008 版本的时候，当我Design更改表然后保存时出现如下错误： Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have ei...
Sql Server'不允许保存更改'错误►防止保存需要重新创建表的更改
asdfgh0077的博客
04-13 894
When I create a table in SQL Server and save it, if I try to edit the table design, like change a c
SqlServer2008修改表时出现“save changes is not permitted…”解决方法
weixin_34008933的博客
06-03 220
最近使用SqlServer2008，发现在修改完表字段名或是类型后点击保存时会弹出一个对话框，对话框内容大致如下 Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made...
SQL Server Error: Saving Changes is not permitted. The changes you have made require the following t
yandao的博客
01-12 671
问题 修改数据库表的时候，无法选择保存，提示：saving changes is not permitted,如下图 解决方案 Open SQL Server Management Studio From the file menu, choose Tools à Options From the left menu, choose Designers Uncheck the box entitled Prevent saving changes that require table re-creati
Saving changes is not permitted. The changes that you have made require the following tables to be d
hbu_pig的专栏
05-17 2569
Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. ERROR: “Saving changes is not permitted. The changes that you have made req
SQL2012 问题Saving changes is not permitted. （修改表时无法保存）
zark721的博客
03-09 1191
感谢原文作者: http://blog.csdn.net/yenange/article/details/6569909 弹出如下信息. Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.You have
MSSQL 2008 Saving changes is not permitted. THe changes you have made require the following table to
lnwaycool的专栏
07-17 1205
2012-08-05 18:48        by        周国选,        138阅读,        0评论,        收藏,        编辑 When I try to update the schema of a table I have received a error below. “Saving changes is not permi
SQL2008 Saving changes is not permitted. （修改表时无法保存）
我想我是海 冬天的大海 心情随风轻摆
06-27 2839
弹出如下信息. 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 cant re-created or enabled th
Cleartext HTTP traffic to www.baidu.com not permitted
最新发布
05-29
好的，我现在需要解决用户遇到的“CleartextHTTP trafficto www.baidu.com notpermitted”问题。这个问题通常出现在Android应用尝试使用HTTP明文传输，而Android9及以上版本默认禁止这种行为。首先，我得确认用户...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值