Apache Derby DB Error Code 42Z19 – Column ‘‘ is being referenced by at least one fo

In this blog post, let’s learn about the error message “42Z19- Column ‘‘ is being referenced by at least one fo” in Apache Derby Database and the description of the error.

Error Message

42Z19- Column ‘‘ is being referenced by at least one fo

Error Details

Column ‘‘ is being referenced by at least one foreign key constraint ‘‘. To alter the length of this column, you should drop referencing constraints, perform the ALTER TABLE and then recreate the constraints.