Delete data: delete()

Performs a DELETE on the table.

JavaScript

const { data, error } = await supabase

.from('cities')

.delete()

.match({ id: 666 })

Parameters

• __namedParametersrequiredobject

  No description provided.

  Properties

  • returningrequiredminimal | representation

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

  • countrequirednull | exact | planned | estimated

    Count algorithm to use to count rows in a table.

Notes

• 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.

Examples

Delete records

JavaScript

const { data, error } = await supabase

.from('cities')

.delete()

.match({ id: 666 })