Deleting ALL ItemsName() in a single Query in SimpleDB

Question

HI,

I want to delete all ItemNames in single query in simpledb. whether it's possible in simple db.If possible please give the query for deleting all items in simple DB

Thanks senthil

Answer 1

SimpleDB doesn't have any way to delete multiple records with a single query, and there is no equivalent to 'TRUNCATE TABLE'.

Your options are either to delete records one at a time or to delete the entire domain.

Answer 2

Use the DeleteDomain operation to delete an entire domain. You can re-create the domain using CreateDomain afterward.