Hi, > if I drop the unique constraint it doesn't drop the index.
I can't reproduce this problem using the current version of H2. See my test case below. What version of H2 do you use? Could you provide a reproducible test case? drop table test; create table test(a int, b int); alter table test add constraint x unique(a, b); select distinct index_name from INFORMATION_SCHEMA.INDEXES; -- X_INDEX_2 alter table test drop constraint x; select distinct index_name from INFORMATION_SCHEMA.INDEXES; -- no rows Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
