Hi, > Actually I just updated to the latest nightly build (106) using the > "svn update" and the ALTER TABLE DROP PRIMARY KEY did work for me. > My previous H2 version where it did not work was 104. > > What is the recommended way to get rid of the primary key constraint > in my case ?
If you don't want to upgrade, you could use SCRIPT TO '...', edit the script manually, then create a new database, and run RUNSCRIPT FROM '...' to recreate the database. 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 -~----------~----~----~----~------~----~------~--~---
