Supabase Extended icon

Supabase Extended

Interact with Supabase database and storage

Actions27

Database → Drop Table

AI-generated

Summary

Drop an existing table from the Supabase database by executing a custom DROP TABLE SQL query via the exec_sql RPC function.

Inputs

  • tableName (required) — The name of the database table to drop.
  • cascade — Whether to append CASCADE to automatically drop objects that depend on the table.

Output shape

a single record

Returns an object containing operation ('dropTable'), tableName, the executed SQL statement, and a success boolean status flag.

Examples

Example 1: Drop a temporary table

tableName: "temp_staging_data", cascade: false

Example 2: Drop a table with dependent foreign key references

tableName: "legacy_orders", cascade: true

Links

Discussion