I want to use prisma on an existing database. Now that I'm researching it, I realise that all my tables and columns are incorrectly named. I would like to correct the names, but I don't want to lose my data.
I did a prisma "pull" so I have a schema of my current database. But then I don't quite understand how (if possible) do I rename my tables and columns using the schema.
What are my options? Can I change the schema.prisma and make prisma take care of all the "alter" statements? How do I do this?
It's not natively supported yet. There is a Feature Request to handle renames effectively.
You can use this technique to rename your tables and fields without dropping the data.
prisma migrate dev --create-only
schema.prisma
fileprisma migrate dev