Hi, I think you would need to do that yourself. You could write a user defined aggregate function, but then how to run it against all columns of a table? It's probably easier to write your own function that traverses over all tables (using database metadata calls to retrieve the list of tables), and then reads all data and calculate the checksum.
Regards, Thomas Hi! Is there a fast way to retrieve or calculate a checksum for a whole table or the whole database? I need it to validate the correctness of a backup, when I re-read a backup-file (with runscript) to a separate in-memory database. Best regards, Johan Berg -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
