File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
how to drop hsql constraint
Joined: Jun 11, 2010
Jun 16, 2010 00:32:48
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
Data Conversion Process
Drop Primary Key Constraint
Regarding Foreign Key Restricts when Alter data type in sql table
problem while inserting values
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2014