Are the DELETE and UPDATE SQL Commands Supported?

Category: azure documentdb


Ryanhav on Thu, 20 Apr 2017 03:37:17

Is SELECT the only SQL command you can run as a query?

Are DELETE and UPDATE supported?



Aravind Ramachandran on Thu, 20 Apr 2017 05:23:07

Yes. DocumentDB provides native methods like POST, PUT, and DELETE (CreateDocumentAsync, ReplaceDocumentAsync and DeleteDocumentAsync in .NET SDK) in place of DML. 

You can also use DocumentDB's stored procedure support for procedural logic like UPDATE..WHERE and other stored procedure-like logic.

Ryanhav on Thu, 20 Apr 2017 12:01:33

Thanks Aravind, I was wondering if UPDATE and DELETE are supported through using SQL syntax - when you run a query?