To delete all product related data, use the following query:

Due to the constraints it will delete all related data from other tables as well.

Deleting all products using SQL
You want or need help implementing this solution? Maybe you did not find what you were looking for? Contact me and I will assist you with whatever Magento problem troubles you!