Supabase Extended icon

Supabase Extended

Interact with Supabase database and storage

Actions27

Database → Drop Index

AI-generated

Summary

Drop an existing database index in Supabase using an RPC call. Executes a SQL DROP INDEX query with an optional CASCADE clause.

Inputs

  • indexName (required) — The name of the database index to remove.
  • cascade — Whether to automatically drop objects that depend on the index.

Output shape

a single record

Returns an object containing operation, indexName, the generated SQL statement, and success status. Requires the exec_sql RPC function to be defined on your Supabase instance.

Examples

Example 1: Drop a custom database index

Set indexName to idx_users_email

Example 2: Drop an index with cascade option

Set indexName to idx_orders_customer_id and set cascade to true

Links

Discussion