3086错误无法从指定的表中删除 [英] 3086 error could not delete from specified tables

问题描述

尝试删除SQL Server表时，在第30行发生错误。我无法理解的是，我是否在第24行删除同一个SQL Server中的表而没有任何错误？我正试图以同样的方式处理它。

Error is happening on line 30 below when trying to delete an SQL server table. The thing I cannot get my mind around, is I am deleting a table in the same SQL Server on line 24 without any errors? And I''m trying to handle it the same way.

展开 | 选择 | Wrap | 行号

推荐答案

错误描述没有多大意义。我想我会从检查以下内容开始：


Doublecheck您的拼写正确，包括大写字母。


我没有工作很多SQL服务器。这可能是相关记录的问题吗？如果您删除该记录，另一条记录将没有孤儿？访问可以强制执行参考entegrity，尽管我认为它只适用于访问数据库。 SQL Server是否以及如何实现相同我只是不太了解。


我要研究的第三个选项是，是否有任何与表相关的触发器，导致要删除的删除。


要检查的另一件事是，可以直接打开SQL服务器，并尝试从服务器环境中执行SQL语句。


希望对你有所帮助，让我们听听它是怎么回事！

The error description doesn''t give much to go. I guess I would start by checking the following:

Doublecheck that you have the spelling correct, including Capital Letters.

I have not worked much with SQL server. Could it be a issue of related records? That if you delete that record, another record would be left without an orphan? Access can enforce referential entegrity, allthough I believe its only for an access database. Whether and how SQL server implements the same I simply don''t know enough about.

The third option I would look into, is whether there are any triggers related to the table, causing the deletion to be cancelled.

Another thing to check, could be to open the SQL server directly, and try to execute the SQL statement from within the server environment.

Hope that helps you, lets hear how it goes!

拼写是正确的，我已经将表名复制并粘贴到VBA中了。


桌子上没有触发器


我确实进入了SQL Server，它不喜欢*在删除*中。它在服务器中运行为从SupperSummary删除。当我使用从dbo.SupperSummary删除时仍然会出现相同的错误在VBA中。


如果我将dbo.SupperSummary改为SupperSummary，它就像我想的那样会出错，当它找不到表时。

Spelling is correct, I copied and pasted of the table name into the VBA already.

No triggers on the table

I did go into the SQL Server and it did NOT like the "*" in Delete * from. It ran in the Server as "Delete from SupperSummary". Still getting same error when I use "Delete from dbo.SupperSummary" in VBA.

If I change dbo.SupperSummary to just SupperSummary it errored out like I thought it would, when it couldn''t find the table.

正如我所说，在SQL服务器上没有太多经验，但如果是我，接下来我会尝试：

As I said, not much experience in SQL server, but if it was me, next thing i would try:

< span class =codeLinkonclick =Blur（this，this.parentNode.parentNode，getChildren（this），true）;>展开 | 选择 | Wrap | 行号

这篇关于3086错误无法从指定的表中删除的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！