Register / Login
Win a copy of
Murach's Python Programming
this week in the
this forum made possible by our volunteer staff, including ...
Roel De Nijs
Stephan van Hulst
JDBC and Relational Databases
how to drop hsql constraint
posted 6 years ago
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>
It is sorta covered in the
JavaRanch Style Guide
Boost this thread!
Drop Primary Key Constraint
problem while inserting values
Regarding Foreign Key Restricts when Alter data type in sql table
Data Conversion Process