File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes how to drop hsql constraint Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to drop hsql constraint" Watch "how to drop hsql constraint" New topic

how to drop hsql constraint

Renz Alexander

Joined: Jun 11, 2010
Posts: 28
i've been searching from google for hours now but i still can't seem to find out how to delete an fk constraint in hsql. can anyone help

well i figured it out after i just posted for those who wants to know first

"ALTER TABLE <tablename> DROP CONSTRAINT <constraintname>"

to find the constraint check for in the hsql db script with the

ALTER TABLE <tablename> ADD CONSTRAINT <constraintname>

this then remove the constraint and allows you to drop the column as normal

ALTER TABLE <tablename> DROP column <columnname>
I agree. Here's the link:
subject: how to drop hsql constraint
It's not a secret anymore!