Is there any way I can rename primary key constraint in spring jpa ?
I am using Oracle database, but it renames primary key constraint by SYS_C followed by some random number, I want to give it a custom name like instance_details_pkey. Please refer to this image constraint_names
You can control the generated PK constraint names with a few small mods in a custom dialect. For example, here's how to do it in Oracle (the same approach works for SQLServer & DB2): How to choose DDL Primary Key constraint names with JPA/Hibernate
Assuming that your DDL is handled by Spring-Data and subsequently Hibernate, what you seek to do is not possible out of the box. There is in fact an open request to implement something like this for Hibernatem which can be found here.
As mentioned in an another answer, you could go ahead and do something custom that could handle this, but I would advise against it. In fact, I would advise against even using Hibernate to create the default schema.
