Geek Answers Handbook

Delete all records in an Azure table

I have an Azure storage table and has 3k + entries.

What is the most efficient way to delete all rows in a table?

+8
c # azure azure-storage azure-table-storage
source share
1 answer

For 3000 entries, the easiest way is to delete the table. However, note that when a table is deleted, it will not be deleted at that time, but is placed in some queue to be deleted, and actually deleted after a while. This time depends on the load on the system + the number of objects in the table. During this time, you will not be able to recreate this table or use this table.

If it is important for you to continue using the table, the only option is to delete the objects. For faster deletion, you can look at deleting objects using Entity Batch Transactions . But to delete objects you will need to get the objects first. You can speed up the selection process only by selecting PartitionKey and RowKey entity attributes instead of loading all the attributes as soon as these two attributes are needed to delete the object.

+15
source share

More articles:


All Articles