How to remove all related products from all products at once?

[JoeSchiaffi]

Hi there,

I run a shop with over 12.000 products, each products has manual and static related products inserted by me manually for every product (in very product sheet, after the Supplier field, there is the "RElated Products" field and there you can add manually each related product, its a basic prestashop function, no extra module for this). Now, I've purchased and installed a module that dinamically put related products and I'm very happy with it: my only problem is that now I would like to remove all the manual and static products from every single product but as I've said: over 12.000 products, it's impossible to do it manually one by one. 

So, is there a way (maybe an SQL query?) to remove all related products from all products at once?

[webprog]

Hello, yes, you can clear ps_accessory table or rows manually.

[JoeSchiaffi]

Thanks mate, I've cleaned the ps_accessory table and my problem has been fixed in 1 click, just as I wished, thanks a lot