Unique constraint failed on the fields: (

id

) ERROR T^T... Do you know how to reset pk?..

await prisma.user.deleteMany()
console.log(await prisma.user.findMany()); // []
await prisma.user.create({
      data: {
        id: '123',
      },
    });   // Error

@kkangsan 👋 You can change the pk of the record that has the

id

123

and then create a new record.

ty, Is the existing pk not usable?

If it’s already referenced in another record then no.

Is there a way to reset the DB table to its initial state?

You can reset your database using this.

can i use prisma cli in code ??

Only shell. To use it in code, you would need to use something like

exec

.

https://flaviocopes.com/prisma-clear-database/ I found a blog that is struggling with the same problem as me.