I want to delete a customer that was registered but not activated his account yet. What tables apart from the Customer I have to delete data from?
Thanks in advance
It's enough to click the "Delete" button on a customer details page in admin area.
But if you want to delete it manually (e.g. using SQL commands), then please check [CustomerPassword] and [GenericAttribute] tables.
In some cases (depends on your store configuration) information could be stored into [ActivityLog], [Address], [GdprLog], [ShoppingCartItem] tables
CheckPassword has a cascade so deleting user from customer deletes the entry there.
GenericAttribute though does not. You have to delete it manually