How do I delete an entry in SQL

Question

0.00/5 (No votes)

See more:

I'm kinda beginner in sql but am getting this error-
"The DELETE statement conflicted with the REFERENCE constraint "documents_fk15". The conflict occurred in database "RD_Doc", table "dbo.doc_source", column 'document_id'.
The statement has been terminated."

What I have tried:

The command I tried to run-
"DELETE from documents where document_id = 209965"

Posted 10-Mar-21 5:55am

DragonChasm

Updated 10-Mar-21 7:23am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2021-03-10T06:27:00

You are trying to delete a record from the documents table, but you have related records in the doc_source table which depend on the record you are trying to delete.

You will need to delete the related records from the doc_source table before you can delete the record from the documents table.

If you always want the related records to be deleted, you can set the foreign key constraint to "cascade deletes":
Using DELETE CASCADE Option for Foreign Keys[^]

k5054 · Answer 2 · 2021-03-10T07:23:00

To delete the related records manually, without changing the foreign key to use the CASCADE option, you can do it in two steps:

SQL

delete from doc_source where document_id = 209965;
delete from documents where document_id = 209965;

You may want to wrap that in a transaction and confirm that you've only deleted the records from doc_source that you intended to, before you delete from documents. If this is Important Data, then perhaps get a backup of the data before you proceed. If this is only a database you are using for educational purposes, and can repopulate easily, you might be able to afford to skip the backup.

How do I delete an entry in SQL

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0