Delete

The delete statement deletes rows in the database.

The delete statement includes a filter expression (see …) where you specify which rows to delete.

 type Customer struct {
  id int primaryKey
  name string
 } end

 insert Customer {id: 1, name: 'Amy Chang'}
 delete Customer[1]  //deletes one row

In the above example we use a primary key filter ("[1]") to identify the row to be deleted.