Spring boot ddl auto generator

Question

I'm using spring boot with spring.jpa.hibernate.ddl-auto=create, but when application restarted, all tables drops and creates again. Is there some way to avoiding re-creation for already existing tables?

Answer 1

The list of option which is used in the spring boot are

• validate: validate the schema, makes no changes to the database.
• update: update the schema.
• create: creates the schema, destroying previous data.
• create-drop: drop the schema at the end of the session
• none: is all other cases.

So for avoiding the data lose you use update

Answer 2

spring.jpa.hibernate.ddl-auto=update 

hibernate.ddl-auto should usually not be used in production.