Javascript Reference v1.0

Delete data

Performs a DELETE on the table.

delete() should always be combined with filters to target the item(s) you wish to delete.
If you use delete() with filters and you have RLS enabled, only rows visible through SELECT policies are deleted. Note that by default no rows are visible, so you need at least one SELECT/ALL policy that makes the rows visible.

__namedParameters

Optional

object

returning

Optional

object

If `true`, return the deleted row(s) in the response.

count

Optional

object

Count algorithm to use to count rows in a table.


const { data, error } = await supabase
  .from('cities')
  .delete()
  .match({ id: 666 })