Removing attachment from DB

[cityofangelus]

Is there a hack that does this?

I need one that completely deletes the attachments from the DB not just from the forums..

I have looked but can only find ones that delete attachments that are viewable on the forums..

Thanks

Lucy

[Xenon]

DELETE FROM attachment
UPDATE post SET attachmentid=0

afterwards run update counters :)

[cityofangelus]

Xenon

I take it this deletes all the attachments in the DB including the ones on the forum?

If so I obviously don't want to delete the ones on the forum hence why I asked if there was a hack where I can view the attachments...

I was told that when you delete an attachment of main view it stays in the DB this is what I want to get rid of as my DB is getting too large..

Thanks

[Xenon]

right, this queries delete all attachments out of the db....