[
https://issues.apache.org/jira/browse/DERBY-7121?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17390979#comment-17390979
]
Richard N. Hillegas commented on DERBY-7121:
--------------------------------------------
The DDL doesn't compile for me. In particular, the empty column lists on the
foreign keys look wrong.
Try using DROP INDEX to remove the unwanted unique index. ALTER TABLE ... DROP
only works on constraints, not on indexes.
> DROP UNIQUE KEY not working
> ---------------------------
>
> Key: DERBY-7121
> URL: https://issues.apache.org/jira/browse/DERBY-7121
> Project: Derby
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 10.15.2.0
> Environment: Own Docker Image based on Ubuntu 20.04, please see here:
> https://hub.docker.com/repository/docker/konnexionsgmbh/apache_derby
> Reporter: Walter Weinmann
> Priority: Major
> Attachments: IssueApacheDerby.pdf
>
>
> I try to drop the FOREIGN KEY, PRIMARY KEY and UNIQUE KEY constraints before
> the INSERT. To do this, I use the DatabaseMetaData class from JDBC. When
> dropping the UNIQUE KEY I get the following error message:
> {{java.sql.SQLSyntaxErrorException: ALTER TABLE failed. There is no
> constraint 'KXN_SCHEMA.SQL00000166-6f554487-017a-f4fd-c9dc-000016e126' on
> table '"KXN_SCHEMA". "COUNTRY_STATE"'.}}
> Details about the error and the database environment can be found in the
> attached PDF document.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
