I got error “The DELETE statement conflicted with the REFERENCE constraint”

The error means that you have data in other tables that references the data you are trying to delete.

You would need to either drop and recreate the constraints or delete the data that the Foreign Key references.

Suppose you have the following tables

dbo.Students
(
StudentId
StudentName
StudentTypeId
)


dbo.StudentTypes
(
StudentTypeId
StudentType
)

Suppose a Foreign Key constraint exists between the StudentTypeId column in StudentTypes and the StudentTypeId column in Students

If you try to delete all the data in StudentTypes an error will occur as the StudentTypeId column in Students reference the data in the StudentTypes table.

EDIT:

DELETE and TRUNCATE essentially do the same thing. The only difference is that TRUNCATE does not save the changes in to the Log file. Also you can’t use a WHERE clause with TRUNCATE

AS to why you can run this in SSMS but not via your Application. I really can’t see this happening. The FK constraint would still throw an error regardless of where the transaction originated from.

Related Posts:

  1. SQL Insert Query Using C#
  2. What represents a double in sql server?
  3. Convert SQL to LINQ Query
  4. The provider did not return a ProviderManifestToken string Entity Framework
  5. .Net 4.8 Support for Windows 10 ends in 26 days?
  6. What is a NullReferenceException, and how do I fix it?
  7. How do I get a random YouTube video with the YouTube API?
  8. What is a NullReferenceException, and how do I fix it?
  9. Unexplained crashes related to ntdll.dll
  10. I am getting Failed to load resource: net::ERR_BLOCKED_BY_CLIENT with Google chrome
  11. CS0120: An object reference is required for the nonstatic field, method, or property ‘foo’
  12. What is the difference between declarative and imperative paradigm in programming?
  13. Group by in LINQ
  14. Input string was not in a correct format
  15. The request was aborted: Could not create SSL/TLS secure channel
  16. C# An established connection was aborted by the software in your host machine
  17. OnCollisionEnter() not working in Unity3D
  18. Difference between virtual and abstract methods
  19. How to open .dll files to see what is written inside?
  20. how does Request.QueryString work?
  21. C# Java HashMap equivalent
  22. System.Net.Http: missing from namespace? (using .net 4.5)
  23. Windows .NET API / Windows 7 / Bluetooth communication with Intel Curie Arduino / Genuino 101
  24. WFP Grid: MouseRightButtonDown firing occuring BEFORE SelectionChanged on grid. Causing syncing issue
  25. Can’t add script component because the script class cannot be found?
  26. ‘do…while’ vs. ‘while’
  27. Visual Studio /**/ comment shortcut?
  28. Unable to resolve service for type while attempting to activate
  29. Multiple Inheritance in C#
  30. Wait one second in running program
  31. Deserialize JSON with C#
  32. “Error while trying to run project: Unable to start program”. Can run program only once. Then VS needs restart
  33. What is WebResource.axd?
  34. Associating enums with strings in C#
  35. Proper Linq where clauses
  36. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details
  37. How to resolve this System.IO.FileNotFoundException
  38. What is the best way to implement a “timer”?
  39. C# compiler error: “not all code paths return a value”
  40. How do I read and parse an XML file in C#?
  41. SmtpException: Unable to read data from the transport connection: net_io_connectionclosed
  42. How to fix “namespace x already contains a definition for x” error? Happened after converting to VS2010
  43. How can I get the application’s path in a .NET console application?
  44. How do I encode and decode a base64 string?
  45. How to keep console window open
  46. Tree data structure in C#
  47. What is 0x10 in decimal?
  48. Visual Studio: The Operation could not be completed. The parameter is incorrect
  49. IEnumerable vs List – What to Use? How do they work?
  50. Member ‘‘ cannot be accessed with an instance reference
  51. Sequence contains no matching element
  52. when do you need .ascx files and how would you use them?
  53. How to convert code from C# to PHP
  54. How to open a new form from another form
  55. C# – How to convert string to char?
  56. The entity type is not part of the model for the current context
  57. Recommendation for C# Matrix Library
  58. Deep cloning objects
  59. Regular expression “^[a-zA-Z]” or “[^a-zA-Z]”
  60. .NET graph library around?
  61. Input string was not in a correct format
  62. There is no ViewData item of type ‘IEnumerable‘ that has the key country
  63. C# – Rounding Down to Nearest Integer
  64. How to update the value stored in Dictionary in C#?
  65. How to write a comment in a Razor view?
  66. Finalize vs Dispose
  67. How to download a file from a URL in C#?
  68. Calculate a MD5 hash from a string
  69. The model item passed into the dictionary is of type .. but this dictionary requires a model item of type
  70. How can I get the active screen dimensions?
  71. WebException (Status: Protocol Error)
  72. How to add a new row to datagridview programmatically
  73. Catch multiple exceptions at once?
  74. How to delete a file after checking whether it exists
  75. Unexpected character encountered while parsing value
  76. Embedded statement cannot be a declaration or labeled statement
  77. MailMessage.To.Add() throwing exception : “An invalid character was found in the mail header: ‘,’.”
  78. Remove duplicates from a List in C#
  79. How to deserialize xml to object [duplicate]
  80. How can we prepend strings with StringBuilder?
  81. C# conditional operator error Only assignment, call, increment, decrement, await, and new object expressions can be used as a statement
  82. Simulating Key Press C#
  83. No overload for method ” takes 1 argument
  84. Cannot drop database because it is currently in use
  85. Best way to “push” into C# array
  86. Troubleshooting “program does not contain a static ‘Main’ method” when it clearly does…?
  87. Unity 5.2.2 changing Visual Studio back to MonoDevelop
  88. Using FolderBrowserDialog in WPF application
  89. How to make Check Box List in ASP.Net MVC
  90. Is there an equivalent to the C# “var” keyword in C++/CLI?
  91. The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.5.1 Authentication Required?
  92. Quickest way to compare two generic lists for differences
  93. What is the easiest way to encrypt a password when I save it to the registry?
  94. LINQ query on a DataTable
  95. Using .Select and .Where in a single LINQ statement
  96. How to resize an Image C#
  97. Unrecognized escape sequence for path string containing backslashes
  98. C# Dictionary get item by index
  99. Memory Leak caused by System.Drawing.Internal.GPStream
  100. A field initializer cannot reference the nonstatic field, method, or property

Leave a Comment