# dropAllForeignKeyConstraints does not work on Oracle

**URL:** <https://forum.liquibase.org/t/dropallforeignkeyconstraints-does-not-work-on-oracle/1227>\
**Category:** General Discussion\
**Created:** [April 12, 2011, 1:45am UTC](https://forum.liquibase.org/t/dropallforeignkeyconstraints-does-not-work-on-oracle/1227 "2011-04-12T01:45:00Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![quinton.mccombs](https://avatars.discourse-cdn.com/v4/letter/q/e274bd/32.png) [@quinton.mccombs](https://forum.liquibase.org/u/quinton.mccombs)\
**Post date:** [April 12, 2011, 1:45am UTC](https://forum.liquibase.org/t/dropallforeignkeyconstraints-does-not-work-on-oracle/1227/1 "2011-04-12T01:45:00Z")

</div>

Using this tag on Oracle where the constraint has multiple columns results in&nbsp;ORA-02443: Cannot drop constraint &nbsp;- nonexistent constraint. &nbsp;

The problem seems to be caused by the generated SQL used to retrieve the list of foreign keys to drop. &nbsp;Since the columns are also returned in the query, you get one row constraint and column returned. &nbsp;This is causing liquibase to attempt to drop the constraint multiple times. &nbsp;

Created jira issue [CORE-921](http://liquibase.jira.com/browse/CORE-921)