# Is there a way to remove all post revisions from all the posts?

**URL:** <https://meta.discourse.org/t/is-there-a-way-to-remove-all-post-revisions-from-all-the-posts/70001>\
**Category:** Product Support\
**Created:** [13.Сентябрь.2017 20:02:29 UTC](https://meta.discourse.org/t/is-there-a-way-to-remove-all-post-revisions-from-all-the-posts/70001 "2017-09-13T20:02:29Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)\
**Post date:** [13.Сентябрь.2017 20:23:13 UTC](https://meta.discourse.org/t/is-there-a-way-to-remove-all-post-revisions-from-all-the-posts/70001/4 "2017-09-13T20:23:13Z")

</div>

If you know SQL, then it’s two queries away

- delete everything in the `post_revisions` table
- update `version` and `public_version` on the `posts` table to 1

😉

---

_[View the full topic](https://meta.discourse.org/t/is-there-a-way-to-remove-all-post-revisions-from-all-the-posts/70001)._