title: How to clear a Cosmos DB database or delete all items using Azure portal
body: <p>If go to <a href="https://portal.azure.com" rel="nofollow noreferrer">https://portal.azure.com</a>, open our Azure Cosmos DB account (1) --&gt; Data Explorer (2) --&gt; Click on users (3) --&gt; Click on New SQL Query:</p>
  <p><a href="https://i.stack.imgur.com/FqlHg.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/FqlHg.png" alt="Azure screenshot 1" /></a></p>
  <p>Azure will open a text box to enter a Query:</p>
  <p><a href="https://i.stack.imgur.com/HRz5D.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HRz5D.png" alt="Azure screenshot 2" /></a></p>
  <p>I've found that Cosmos DB does not allow the usage of DELETE instead of SELECT: <a href="https://stackoverflow.com/a/48339202/1198404">https://stackoverflow.com/a/48339202/1198404</a>, so I should do something like:</p>
  <pre><code>SELECT * FROM c DELETE c
  SELECT * FROM c DELETE *
  </code></pre>
  <p>But none of my attempts worked.</p>