H2 - How to truncate all tables?

sql database h2
Filip picture Filip · Nov 20, 2014 · Viewed 12.9k times · Source

I assume there is a way of doing this from code, at least some good workaround.

Please consider that I do not want to delete all tables (I've seen this command), just to delete rows from them but to keep existing schema and all constraints.

Maybe I can somehow obtain the list of all tables from metadata and apply TRUNCATE command for each separately? But what about their relations and foreign keys?

Any Idea?

Answer

Julian Ladisch picture Julian Ladisch · Nov 20, 2014

You may do it this way:

Related questions

Can I have H2 autocreate a schema in an in-memory database?

(I've already seen the H2 database In memory - Init schema via Spring/Hibernate question; it is not applicable here.) I'd like to know if there's a setting in H2 that will allow me to auto-create a schema upon connecting …

Read More
Defining a Foreign key constraint in H2 Databases

I am new in coding so I made a tables in SQL server and it worked, so i used the same command in H2 and it said I have a syntax problems with the second table, someone can help? CREATE …

Read More
How do I allow multiple users to connect to my H2 database simultaneously?

I am using H2 for database management, and this is what I would like to do: I would like to allow multiple users to access a database at the same time. I've read a bit about "MULTI_THREADED=TRUE", "LOCK_…

Read More