Hi. I've created a table with unique constraint on one column with liquibase. I forgot to name that constraint, so a random name was choosen by 2=h2 (or liquibase, doesn't matter). Now I need to drop that constraint, but I have no success.
I should obtain a constraint name by quering: select constraint_name from information_schema.constraints where table_schema = 'PUBLIC' and TABLE_NAME='foo' and COLUMN_LIST ='column_name'; .. but I can't use that result this way: alter table foo drop constraint (select constraint_name ...) Any tip how to use result of that select as argument for alter table request? Thx Dusan -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
