To delete all product related data, use the following query:
DELETE FROM catalog_product_entity;
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!