Deleting ALL ItemsName() in a single Query in SimpleDB

HI,

I want to delete all ItemNames in single query in simpledb. whe开发者_JS百科ther it's possible in simple db.If possible please give the query for deleting all items in simple DB

Thanks senthil

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.

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

SimpleDB supports batch delete now: http://docs.amazonwebservices.com/AmazonSimpleDB/latest/DeveloperGuide/SDB_API_BatchDeleteAttributes.html

But you can only do 25 at a time.

If you want to delete the entire domain, do as Scrappydog suggest and delete the domain. Much faster than deleting one by one.