27 Sep 19 ·  nVector in Bigquery ·        Bookmark ·  Report ·  More actions.. Lock comments ·  Pin thread

Delete command syntax in Google Bigquery

Use the DELETE statement when you want to delete rows from a table

To delete all rows from a table (i.e to truncate a table)

DELETE FROM dataset.DetailedInventory WHERE true;

DELETE with WHERE clause

DELETE FROM dataset.Inventory WHERE quantity = 0;

Alternately, you can use DELETE with the EXISTS clause:

DELETE FROM dataset.Inventory
(SELECT * from dataset.NewArrivals
WHERE Inventory.product = NewArrivals.product);


posted on 27 Sep 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds