if I use this command

npx prisma db pull --force

- do I run a risk of dropping all tables in my db? What I am trying to do is pull all the tables from my production db to my local machine

Usually if there are critical changes in your dbms like changing unique contraints, Prisma migration will warn you that it will drop your tables before migration. However, you can resolve this conflict manually. Then Prisma migration won't drop the tables. https://www.prisma.io/docs/guides/database/developing-with-prisma-migrate/troubleshooting-development#failed-migrations