Greetings, I need to be able to reset a column to its default value, as stated in the metadata. I'm not very au fait with SQL, but I have done some web searching and found that, at least in some SQL versions, this is possible with syntax like UPDATE TABLE_NAME SET COLUMN_NAME = DEFAULT [WHERE...]
but this isn't working in my version of h2 (2006-08-31). I have just downloaded the 2009-09-04 version of h2, but the SQL syntax doesn't show any change to the UPDATE command, so I'm assuming that the new version won't do it either. Is there some way to do what I need to do? Many thanks :-) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
