# How to delete all data in Local DB?
**URL:** https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912
**Category:** Questions about Thunkable X
**Tags:** beginner
**Created:** [June 14, 2020, 4:15am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912 "2020-06-14T04:15:35Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@farmershubbysheg](https://community.thunkable.com/u/farmershubbysheg)
#### Post date: [June 14, 2020, 4:15am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/1 "2020-06-14T04:15:35Z")
Hi everyone, how can i delete all data in my Local DB, from row 1 to the length of the list? can anyone show me a sample blocks? please… first i was thinking it was because of cache, but it was stored in the LOCAL DB, and i want to update i from time to time, by deleting old data then after user click a “store” it will load another “data”
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 14, 2020, 6:59am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/2 "2020-06-14T06:59:34Z")
Hi,
You can’t delete rows, but you can write an empty string to all cells (or some other character that will indicate that there is no data)
---
### Author:  [@farmershubbysheg](https://community.thunkable.com/u/farmershubbysheg)
#### Post date: [June 14, 2020, 7:38am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/3 "2020-06-14T07:38:36Z")
but there’s a block here that say “delete row”, then i dont delete row, also each data duplicate, is it a bugs? or do you have any recommended way of blocking for deleting all data in Local DB then how to write data to Local DB using list,
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 14, 2020, 8:52am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/4 "2020-06-14T08:52:41Z")
“row id” is a row ID, not an ordinal number, as you and some other users believe.
LocalDB blocks
You are not using Local DB, but Data Source, which actually has a block for deleting a row by its ID.
---
### Author:  [@farmershubbysheg](https://community.thunkable.com/u/farmershubbysheg)
#### Post date: [June 14, 2020, 9:44am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/5 "2020-06-14T09:44:20Z")
im very sorry as im really new in thunkable, im sorry it was the LocalDB in the “data sources” that im using in data listview where i load all data here 
after that remove all data again so i can add new datas like refreshing it and show in data listview
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 14, 2020, 11:15am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/6 "2020-06-14T11:15:22Z")
Using the delete block, you can delete only those rows that you created using the create block and then saved the row id somewhere else
---
### Author:  [@Michael\_Rogulla](https://community.thunkable.com/u/Michael_Rogulla)
#### Post date: [June 14, 2020, 12:26pm UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/7 "2020-06-14T12:26:48Z")
Hi @actech,
in my opinion there should be a way to iterate over the entries of a data source. That way I could reuse the information that is stored in the data source or search for entries. Right now we can choose with a data list viewer, but I am missing a way to search through the data source.
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 14, 2020, 3:25pm UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/8 "2020-06-14T15:25:36Z")
Hi,
If you think there is such a way, can you show it to me? I’m always happy to find out what I don’t know.
---
### Author:  [@farmershubbysheg](https://community.thunkable.com/u/farmershubbysheg)
#### Post date: [June 15, 2020, 3:08am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/9 "2020-06-15T03:08:49Z")
can you show please, by creating a data in a data sources using localdb then delete all data by row, i will appreciate it so much, as my way is not working (image above)
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 15, 2020, 7:01am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/10 "2020-06-15T07:01:06Z")
The DataSource is a raw, very slow, and insufficiently functional component. For this reason, I don’t want to waste time working with him. I prefer to ride a work bike rather than a motorcycle that will be repaired in a few months. I think you understand me.
---
### Author:  [@Michael\_Rogulla](https://community.thunkable.com/u/Michael_Rogulla)
#### Post date: [June 15, 2020, 10:45am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/11 "2020-06-15T10:45:41Z")
Hi @actech,
yes, the data source is indeed very slow. It **could** be a good alternative to the local db, but there lack several features, like iterating. The only reason to work with it are the nice data list viewers, which look prettier than the standard list view.
---
### Author:  [@actech](https://community.thunkable.com/u/actech)
#### Post date: [June 15, 2020, 11:52am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/12 "2020-06-15T11:52:16Z")
I’m afraid that iPhone and Smartfone users will not be able to work with lists . If the beautiful list is slow, the user will swear and throw the app in the trash. If the list works fast but looks ugly, the user will swear and throw this app in the trash, too.
---
### Author:  [@ioannis](https://community.thunkable.com/u/ioannis)
#### Post date: [November 8, 2024, 11:25am UTC](https://community.thunkable.com/t/how-to-delete-all-data-in-local-db/613912/13 "2024-11-08T11:25:45Z")