Deleting a customer from database

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

Thanks.

CheckPassword has a cascade so deleting user from customer deletes the entry there.

GenericAttribute though does not. You have to delete it manually