aspose file tools
The moose likes JDBC and the fly likes how to drop hsql constraint Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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 agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: how to drop hsql constraint
 
Similar Threads
Data Conversion Process
Regarding Foreign Key Restricts when Alter data type in sql table
problem while inserting values
Drop Primary Key Constraint
column name