If I create a table with an AUTO_INCREMENT field, I see it automatically creates a sequence. The sequence name is something like SYSTEM_SEQUENCE_..................... Is there a way to know what's the sequence name associated to a table and the auto increment field? How is the sequence name generated?.
As a work around I can first create the sequence and then add DEFAULT (NEXT VALUE FOR SEQUENCENAME) NOT NULL NULL_TO_DEFAULT SEQUENCENAME Thanks. Julio Jiménez --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
