blocks|key|3734216|text|工作原理:重启。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3734217|重新启动整个计算机正常工作。|3734218|简单地重新启动db服务器是不起作用的，但是重新启动整个机器就可以了。|3734219|我不知道为什么！|3734220|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

What worked: rebooting.

Restarting the entire computer worked.

Simply restarting the db server didn't work, but rebooting the entire machine did.

I have no idea why!

blocks|key|1123222|text|我能够通过关闭并重新打开SQL+Management+Studio来解决此问题。我敢打赌，简单地切断与服务器的连接并恢复它将会起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1123223|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I was able to fix this problem by closing SQL Management Studio and re-opening it. I bet simply severing the connection to the server and reinstating it would work.

blocks|key|4579429|text|仅断开与SQL+Management+Studio的连接不起作用。但是重新启动SQL+Management+Studio起作用了。仍然比重启系统要好。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4579430|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Just Severing the connection from SQL Management Studio did not work. But restarting the SQL Management Studio worked. Still better than restarting the system.

blocks|key|1117921|text|我知道这很古老，但我遇到了同样的问题。我在这里找到了解决方案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1117922|http://weblogs.asp.net/atlaszhu/archive/2010/04/04/sql-server-2008-database-diagram-quot-saving-changes-is-not-permitted-quot.aspx|offset|length|1117923|这基本上是说，在“表和数据库设计器”部分中有一个名为“防止保存更改需要重新创建表”的选项-当选中此选项时，您将收到您所询问的错误。|1117924|当我禁用此选项时，我能够保存我的数据库图表。|1117925|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|3M|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@$D|S|E|T|1|U]]|A|$]]|$1|F|3|G|5|6|7|V|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|W|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|C]]]]

I know this is old, but I came across this same problem. I found the solution here:

<a href="http://weblogs.asp.net/atlaszhu/archive/2010/04/04/sql-server-2008-database-diagram-quot-saving-changes-is-not-permitted-quot.aspx" rel="nofollow noreferrer">http://weblogs.asp.net/atlaszhu/archive/2010/04/04/sql-server-2008-database-diagram-quot-saving-changes-is-not-permitted-quot.aspx</a>

which basically says there is an option in the "Tables and Database Designers" section called "Prevent saving changes the require table re-creation" - when this is checked, you will receive errors like you've asked about.

When I disabled this option, I was able to save my database diagram.

blocks|key|3734100|text|如果您使用的是模式工具，那么重新创建模式可能会更简单。根据我的经验，我发现这个工具有一些奇怪的问题，可以通过简单地重新创建模式(它的图形视图，而不是整个db+:)来修复。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3734101|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you're using the schema tool, it may be simpler to recreate the schema. In my experience I've found that tool to have some odd quirks that have been fixed by simply recreating the schema ( the graphical view of it, not the whole db :) )

blocks|key|3734150|text|在MSDN中，要从可视数据库设计器中删除表：|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3734151|3734152|blockquote|3734153|3734154|从数据库关系图中选择要从表中删除的表，然后从快捷菜单中选择“remove.|3734155|Right-click+|unordered-list-item|3734156|”。|ordered-list-item|3734157|3734158|3734159|-或者-|3734160|按ESC键。|3734161|如果由于您在数据库关系图中所做的编辑而导致表具有未保存的更改，则会出现一条消息，提示您在删除表之前先保存该表。|3734162|该表将从您的图表中删除，但它将继续存在于数据库中。|style|BOLD|3734163|因此，要删除它，必须在脚本或对象资源管理器(MSDN)中执行此操作：|3734164|用于从数据库中删除表的|3734165|3734166|3734167|3734168|delete.|3734169|Right-click+|3734170|在对象资源管理器中，选择要删除该表的表，然后从快捷菜单中选择删除。|3734171|将显示一个消息框，提示您确认删除。单击是。|3734172|3734173|3734174|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/ms175517.aspx|1|http://msdn.microsoft.com/en-us/library/ms190616.aspx^0|1|4|0|0|0|0|0|0|0|0|0|0|0|0|0|8|F|0|M|4|1|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1S|8|@]|9|@$A|1T|B|1U|1|1V]]|C|$]]|$1|D|3|-4|5|6|7|1W|8|@]|9|@]|C|$]]|$1|E|3|-4|5|F|7|1X|8|@]|9|@]|C|$]]|$1|G|3|-4|5|6|7|1Y|8|@]|9|@]|C|$]]|$1|H|3|I|5|6|7|1Z|8|@]|9|@]|C|$]]|$1|J|3|K|5|L|7|20|8|@]|9|@]|C|$]]|$1|M|3|N|5|O|7|21|8|@]|9|@]|C|$]]|$1|P|3|-4|5|6|7|22|8|@]|9|@]|C|$]]|$1|Q|3|-4|5|6|7|23|8|@]|9|@]|C|$]]|$1|R|3|S|5|6|7|24|8|@]|9|@]|C|$]]|$1|T|3|U|5|6|7|25|8|@]|9|@]|C|$]]|$1|V|3|W|5|6|7|26|8|@]|9|@]|C|$]]|$1|X|3|Y|5|6|7|27|8|@$A|28|B|29|Z|10]]|9|@]|C|$]]|$1|11|3|12|5|6|7|2A|8|@]|9|@$A|2B|B|2C|1|2D]]|C|$]]|$1|13|3|14|5|6|7|2E|8|@]|9|@]|C|$]]|$1|15|3|-4|5|F|7|2F|8|@]|9|@]|C|$]]|$1|16|3|-4|5|6|7|2G|8|@]|9|@]|C|$]]|$1|17|3|-4|5|6|7|2H|8|@]|9|@]|C|$]]|$1|18|3|19|5|6|7|2I|8|@]|9|@]|C|$]]|$1|1A|3|1B|5|L|7|2J|8|@]|9|@]|C|$]]|$1|1C|3|1D|5|O|7|2K|8|@]|9|@]|C|$]]|$1|1E|3|1F|5|O|7|2L|8|@]|9|@]|C|$]]|$1|1G|3|-4|5|6|7|2M|8|@]|9|@]|C|$]]|$1|1H|3|-4|5|6|7|2N|8|@]|9|@]|C|$]]|$1|1I|3|-4|5|6|7|2O|8|@]|9|@]|C|$]]]|1J|$1K|$5|1L|1M|1N|C|$1O|1P]]|1Q|$5|1L|1M|1N|C|$1O|1R]]]]

From <a href="http://msdn.microsoft.com/en-us/library/ms175517.aspx" rel="nofollow noreferrer">MSDN</a>, to delete a table from the Visual Database Designer:

<blockquote>
 <ol>
 <li>In your database diagram, select the table you want to remove.</li>
 <li>Right-click the table and choose Remove Table from Diagram from the
 shortcut menu.</li>
 </ol>
 
 -or-
 
 Press the ESC key.
 
 If the table has unsaved changes as a
 result of edits you made in the
 database diagram, a message prompts
 you to save the table before removing
 it.
 
 The table is removed from your diagram
 but it continues to exist in the
 database.
</blockquote>

So, to delete it, you'll have to do that from script or object explorer (<a href="http://msdn.microsoft.com/en-us/library/ms190616.aspx" rel="nofollow noreferrer">MSDN</a>):

<blockquote>
 To delete a table from the database
 
 <ol>
 <li>In Object Explorer, select the table you want to delete.</li>
 <li>Right-click the table and choose Delete from the shortcut menu.</li>
 <li>A message box prompts you to confirm the deletion. Click Yes.</li>
 </ol>
</blockquote>

blocks|key|514517|text|在任何图表上可能还有该表的任何链接，只需打开DB图表，它就会告诉您该表已被删除。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|514518|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

There might be any link remaining of that table on any diagram just open DB diagrams and it will tell you that this table is removed.

blocks|key|4579545|text|只需关闭SQL+Server+Management+Studio，禁用网络连接(拔下电缆或禁用wifi)，然后重新打开SQL+Management+Studio并重新连接网络即可。现在它应该可以正常工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4579546|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Just close SQL Server Management Studio, disable network connection (unplug cable or disable wifi), re-open SQL Management Studio and reconnect the network. It should work fine now.

Using SQL Server 2008 and I'm doing some schema construction in the Management Studio designer.

I created a table early in the process called "Animal", but then decided to delete shortly after. I deleted it via the tree view in Management Studio (right-click delete).

Now I'm late in the process, I would like to recreate the table "Animal" but with different fields.

The second time round with Animal gets created fine, but when I try to add the table to my diagram I get the message "Table 'Animal' is marked for deletion, can't be added to the diagram or opened in the table designer".

What's the deal? How can I use this table normally again and not suffer from older table naming conflicts?

Alternatively, if the table is marked for deletion, can I actually invoke deletion somehow? Then recreate another table with the same name.

This is a little annoying. Would appreciate any help.

How come the message "Table is marked for deletion" keeps appearing?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

使用SQL Server2008，我正在Management Studio设计器中进行一些架构构造。我在这个过程的早期创建了一个名为"Animal“的表，但不久之后就决定删除它。我通过Management Studio中的树视图删除了它(右键单击delete)。现在我在这个过程中已经晚了，我想用不同的字段重新创建表"Animal“。第二次使用Animal可以很好地创建，但当我尝试将该表添加到我的图

问为什么会一直出现"Table is marked for deletion“消息？
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问为什么会一直出现"Table is marked for deletion“消息？EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问为什么会一直出现"Table is marked for deletion“消息？
EN