This week's book giveaway is in the Design forum.
We're giving away four copies of Building Microservices and have Sam Newman on-line!
See this thread for details.
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 Building Microservices this week in the Design forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "how to drop hsql constraint" Watch "how to drop hsql constraint" New topic
Author

how to drop hsql constraint

Renz Alexander
Greenhorn

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

[edit]
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’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com
 
subject: how to drop hsql constraint
 
It's not a secret anymore!