Hello. There is no such table as INFORMATION_SCHEMA.CONSTRAINTS in supported version of H2, unless legacy information schema was enabled explicitly or due to remote connection from an old driver.
Only outdated unsupported versions of H2 have such table. They all have various bugs with constraints. Referential (foreign key) constraints in them didn't require an existing primary key or unique constraint on referenced columns in the referenced table (in modern versions of H2 such constraint is required). They only need an unique index on them in the referenced table. You need to check referential constraints declared in other tables, most likely one (or some) of them references your old primary key column. You need to drop it too. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/345945b5-924c-413e-9417-09250f6d1572n%40googlegroups.com.
