deleting customers from database customer table

Hello,
What's the proper way to delete user records from the table Customers (with all the related tables data).
for one i have deleted records in the db with deleted= 1 that would not allow me to use those emails again and also i have lot of spam users in db which is nice to get rid to keep records clean.

Thanks in advance
Keli

I use Microsoft Access to open the database - with ODBC Connection
It’s easy to see the data and delete customer records

The deleted = true customers are easy - just sort / filter and delete.
Other than that you need some criteria and a way to know they are spam - not just customers who have not purchased yet.

One criteria might be delete customers older than 2 months who do not have any paid orders.

You can also use MQL Management Studio to write a query to delete (There are probably other tools)

Alternatively you can customise some code to do the above.

Hi Yidna,
Thank you for the reply. Yes i understand it's important to be careful what customers not to delete and i do use sql management studio. But my questions was just want to know the correct query to delete the user and it's existing records from all the other table too. I mean i can just delete the customer just from that table but i'm pretty sure that user records from "Customer" table data might have a relationship to other tables.

Did you get an answer on this?  I'm having the reverse issue.  Trying to import customer data from another system and we're still missing a relationship somewhere. Not certain to which table though.