Hi, > PostgreSQL returns 'pk_person', Derby returns 'PK_PERSON'; HSQLDB and > H2 return the index name; MySQL returns 'PRIMARY'. > > May I ask why do you like to get the constraint name?
Because I'm re-creating SQL from the information returned by the JDBC driver, and using the index name is not the same thing as using the name supplied by the user during creation of the table. It's more a cosmetic thing as all other databases return the name that was specified by the user. Except for MySQL - but then I don't expect anything to work properly with MySQL when it comes to referential integrity :) 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 -~----------~----~----~----~------~----~------~--~---
