SQL2008 Saving changes is not permitted. （修改表时无法保存）

最新推荐文章于 2024-02-27 10:57:15 发布
最新推荐文章于 2024-02-27 10:57:15 发布 · 101 阅读 · 0

本文解决了一个在设计过程中遇到的问题，即在尝试保存更改时出现的错误信息。此错误提示您所做的更改需要相关表格被删除并重建。通过调整工具设置中的特定选项，可以避免这一限制，允许进行必要的设计修改。

弹出如下信息.
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

工具->选项->Designers->表选项->阻止保存要求重新创建表的更改

把这一项uncheck (不选)了就行了.


iteye_20954
关注
2023-02-08 InnoDB Architecture
悟世之路
02-08 481
InnoDB Architecture。
【Oracle11g官方文档阅读】DBA Essentials-中篇
萝卜吃鱼914的博客
07-08 1040
文章目录6 Managing Database Storage Structures7 Administering User Accounts and Security8 Managing Schema Objects 6 Managing Database Storage Structures This chapter discusses using Oracle Enterprise Mana...
【转】 SQL2008修改表结构的时候弹出的提示Saving changes is not permitted.
我想我是海 冬天的大海 心情随风轻摆
05-06 756
<br />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
【SQL】提示：saving changes is not permitted
weixin_43041350的博客
11-15 1012
2. 选择Tools–>Options–>Designers–>Table and Database Designers ,去掉Prevent saving changes that require table re-creation .数据库提示：saving changes is not permitted。1.回到SQL Server Studio(SSMS)首页。不要捉急，这是因为你设置了保存修改时重建表（一般是默认的）修改数据库表的时候，无法选择保存，
Saving changes is not permitted. （修改表时无法保存）
weixin_41579911的博客
06-16 842
弹出如下信息. 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...
SQL Server - Saving changes is not permitted
10-20 958
If you get the following error message when you re-design the table and couldn't save it: Saving changes is not permitted. The change you have made requires the following table to be dropped and
MSSQL·阻止保存要求重新创建表的更改配置
SCscHero的博客
07-16 453
阅文时长 | 0.23分钟 字数统计 | 370.4字符 主要内容 | 1、引言&背景 2、解决方案 3、声明与参考资料 『MSSQL·阻止保存要求重新创建表的更改配置』 编写人 | SCscHero 编写时间 | 2021/7/15 PM9:0 文章类型 | 系列 完成度 | 已完成 座右铭 每一个伟大的事业，都有一个微不足道的开始。 一、引言&背景   完成度：100% a) 应对问题 ..
Oracle Database 12c SQL Fundamentals I Exam Guide Exam 1Z0-061 学习笔记
tavor的专栏
07-13 3251
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
MySQL运维DBA-MySQL8数据备份和恢复-006篇-mysqldump man帮助手册
老韩的Linux云计算架构师进阶之路
02-27 908
MySQL8数据备份和恢复-001-mysqldump man帮助手册。
[SQL Server] Saving changes is not permitted
华山论码
05-21 310
To allow you to save changes after you alter table, Please follow these steps for your sql setting: Open Microsoft SQL Server Management Studio 2008 Click Tools menu options, then click Options Select Designers Uncheck “prevent saving changes that require
SqlServer2008修改表时出现“save changes is not permitted…”解决方法
weixin_34008933的博客
06-03 235
最近使用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...
Saving changes is not permitted.
ustcyb的专栏
10-15 3325
最近要研究Reporting Services便给自己装了MSSQL2008企业版, 正版的哦~~~ 安装的时候要卸载原来的SQL2005 Express Studio. 自然新的SQL Server Management Studio 2008被安装上了. 由于项目经常要修改表结构,没办法,地球上的IT人都知道表结构不能随便修改, 但量客户那头有一个不是程序的程序员,只会简单的拖和拽和控件
SQL2012 问题Saving changes is not permitted. （修改表时无法保存）
zark721的博客
03-09 1205
感谢原文作者: 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
saving changes is not permitted.The changes you have made require the following tables to...
学者-微风
09-24 1162
修改数据库时，提示： 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
MSSQL的“Saving changes is not permitted...”处理方法
在南极与企鹅共舞！
10-25 755
"Saving changes is not permitted"
SQL2008修改表结构的时候弹出的提示. Saving changes is not permitted...
Jeremiah's Wikipedia
03-24 2896
最近要研究Reporting Services便给自己装了MSSQL2008企业版, 正版的哦~~~ 安装的时候要卸载原来的SQL2005 Express Studio. 自然新的SQL Server Management Studio 2008被安装上了. 由于项目经常要修改表结构,没办法,地球上的IT人都知道表结构不能随便修改, 但量客户那头有一个不是程序的程序员,只会简单的拖和拽和控件绑
save change is not permitted
weixin_30737433的博客
06-04 220
https://support.microsoft.com/en-my/help/956176/error-message-when-you-try-to-save-a-table-in-sql-server-saving-change In theOptionsdialog box, clickDesigners. Click to select thePrevent ...
如何解决apt 卸载报错 Removing essential system-critical packages is not permitted. This might break the system.
最新发布
03-03
当使用 `apt` 卸载软件包时，若出现 **Removing essential system-critical packages is not permitted. This might break the system** 错误，说明你尝试卸载的软件包被系统标记为「核心组件」（essential packages...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值