# Remove all oauth tokens + consumers (on test env)

**URL:** <https://discuss.konghq.com/t/remove-all-oauth-tokens-consumers-on-test-env/5871>\
**Category:** Questions\
**Created:** [March 27, 2020, 12:32pm UTC](https://discuss.konghq.com/t/remove-all-oauth-tokens-consumers-on-test-env/5871 "2020-03-27T12:32:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zyxep](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.konghq.com/zyxep/32/2323_2.png) [@zyxep](https://discuss.konghq.com/u/zyxep)\
**Post date:** [March 27, 2020, 12:32pm UTC](https://discuss.konghq.com/t/remove-all-oauth-tokens-consumers-on-test-env/5871/1 "2020-03-27T12:32:29Z")

</div>

Hi,

I have a clone of our production setup right now and upgraded that setup to kong 2.0.1.  
How can i easily remove all consumers + added oauth keys/clients & basic auth to the consumer?

I need to move the cassandra cluster, last time i did it i spent 2 days on moving it because we have a lot of tokens / Consumers created.

---

<div class="post-metadata">

**Author:** ![hbagdi](https://yyz2.discourse-cdn.com/flex036/user_avatar/discuss.konghq.com/hbagdi/32/562_2.png) [@hbagdi](https://discuss.konghq.com/u/hbagdi)\
**Post date:** [March 30, 2020, 4:31pm UTC](https://discuss.konghq.com/t/remove-all-oauth-tokens-consumers-on-test-env/5871/2 "2020-03-30T16:31:27Z")

</div>

> [@zyxep](#):
>
> How can i easily remove all consumers + added oauth keys/clients & basic auth to the consumer?

A CQL query to drop all the rows in the oauth2 tables would be the fastest way.