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: 
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.
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.