Hi, > When retrieving the index information, the automatically generated > index for the primary key is no longer marked as a "primary key" > index.
Sorry I don't understand. To what method / query / column do you refer to? With 'no longer' you mean it was different before? If yes in what version? > Which in my case means that I re-create the correct SQL for the PK > constraint but I also build an additional CREATE UNIQUE INDEX > statement which is incorrect. SELECT * FROM INFORMATION_SCHEMA.INDEXES contains a CONSTRAINT_NAME column, so you could find out if an index belongs to a constraint. 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 -~----------~----~----~----~------~----~------~--~---
