From: <glassfish_at_javadesktop.org>
Date: Wed, 09 Sep 2009 10:47:20 PDT

ij> ALTER TABLE ORGANIZATION DROP CONSTRAINT ORGANIZATION_BANK;
0 rows inserted/updated/deleted

I tried to do the above. But still the deletion of the table was not possible.
So tried the following. It gives an error.

ij> ALTER TABLE ORGANIZATION DROP CONSTRAINT BMNYRGNZTNSRGNZTND;
ERROR 42X86: ALTER TABLE failed. There is no constraint 'APP.BMNYRGNZTNSRGNZTND'
 on table 'APP.ORGANIZATION'.

How to delete the constraints and the tables?

Thanks,
Rajesh
[Message sent by forum member 'rajeshrajesh_123' (rajeshrajesh_123_at_rediffmail.com)]

http://forums.java.net/jive/thread.jspa?messageID=363418