I tried to delete some items from the SQL database but I got an integrity constraint error
<p>I tried the following query to delete some rows from the SQL database but it's showing following error:</p>

<p><strong>Query:</strong> </p>

<pre><code>Delete From Document_Type where Doc_Type_id='case'
</code></pre>

<p><strong>This is the error:</strong></p>

<pre><code>Error starting at line : 4 in command -
delete From Document_Type where Doc_Type_Desc='Case'


Error report -
SQL Error: ORA-02292: integrity constraint (NW_DEV_281015.FK_COMMENTS_DOCUMENT_TYPE6) violated - child record found
02292. 00000 - "integrity constraint (%s.%s) violated - child record found"

*Cause:    attempted to delete a parent key value that had a foreign dependency.

*Action:   delete dependencies first then parent or disable constraint.
</code></pre>

<p>How to solve this problem</p>