JavaScript: Delete data

Perform a DELETE on the table or view.

• 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.
• When using delete().in(), specify an array of values to target multiple rows with a single query. This is particularly useful for batch deleting entries that share common criteria, such as deleting users by their IDs. Ensure that the array you provide accurately represents all records you intend to delete to avoid unintended data removal.

Parameters

• options

  (Required)

  Named parameters

Examples

Delete a single record

const response = await supabase
  .from('countries')
  .delete()
  .eq('id', 1)

Delete a record and return it

const \{ data, error \} = await supabase
  .from('countries')
  .delete()
  .eq('id', 1)
  .select()

Delete multiple records

const response = await supabase
  .from('countries')
  .delete()
  .in('id', [1, 2, 3])