# Deleting multiple rows once - query

**URL:** https://community.glideapps.com/t/deleting-multiple-rows-once-query/62956
**Category:** Ask for Help
**Created:** [June 20, 2023, 7:37am UTC](https://community.glideapps.com/t/deleting-multiple-rows-once-query/62956 "2023-06-20T07:37:00Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)
#### Post date: [June 20, 2023, 7:37am UTC](https://community.glideapps.com/t/deleting-multiple-rows-once-query/62956/1 "2023-06-20T07:37:00Z")

</div>

I’m about to delete multiple rows at once using an action in the editor.

- is it okay if I delete a query result? I know it was made to delete a relation.
- has anyone deleted 2000 rows at once using this, it says this might take time I was wondering how long
- I’m only doing this to test this action and possible backup procedures… will be deleting over 20k rows, is it free as they say in the editor or could it eat up my updates by mistake?

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 20, 2023, 7:54am UTC](https://community.glideapps.com/t/deleting-multiple-rows-once-query/62956/2 "2023-06-20T07:54:06Z")

</div>

> [@abdo](#):
>
> is it okay if I delete a query result? I know it was made to delete a relation.

I don’t believe Glide will allow you to do that (although it probably should).

> [@abdo](#):
>
> has anyone deleted 2000 rows at once using this, it says this might take time I was wondering how long

I’ve deleted tens of thousands of rows in the Data Editor, but not through an action. I’d imagine it will be fairly quick, but you won’t know until you try it.

> [@abdo](#):
>
> I’m only doing this to test this action and possible backup procedures… will be deleting over 20k rows, is it free as they say in the editor or could it eat up my updates by mistake?

If it does incur updates, then I think that would be considered a bug.

---

<div class="post-metadata">

### Author: ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 20, 2023, 8:03am UTC](https://community.glideapps.com/t/deleting-multiple-rows-once-query/62956/3 "2023-06-20T08:03:04Z")

</div>

> [@Darren\_Murphy](#):
>
> > [@abdo](#):
> >
> > is it okay if I delete a query result? I know it was made to delete a relation.
> 
> I don’t believe Glide will allow you to do that (although it probably should).

Correction. It looks like Glide will allow you to do that, but only with regular Glide tables. It doesn’t appear to be supported for Big Tables.

---

<div class="post-metadata">

### Author: ![abdo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abdo/32/36540_2.png) [@abdo](https://community.glideapps.com/u/abdo)
#### Post date: [June 20, 2023, 8:59am UTC](https://community.glideapps.com/t/deleting-multiple-rows-once-query/62956/4 "2023-06-20T08:59:53Z")

</div>

Yes it allows me to do it. I set up the action, just didn’t click the button. I guess i’l try it on some sample data. Way more useful if we can do it on a query, in addition to easily setting up filter, I can also split the data to chunks of 500 or 1000 and make sure it goes well everytime.
