Hi Dirk, You want the CONSTRAINT_NAME column.
Thanks, Jesse Dirk Möbius wrote:
Hi Thomas, is there any reason why H2 modifies constraint names? Example: drop table if exists test; create table test (id int); alter table test add constraint "U_TEST_ID" unique (id); select index_name from INFORMATION_SCHEMA.INDEXES where table_name = 'TEST'; result: "U_TEST_ID_INDEX_2" The same happens for foreign key constraint names. I am unable to retrieve the original name using the JDBC metadata API. Regards, Dirk.
-- 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.
