SSupabaseHelp Center

Guide

Edit Table

6 stepsAgent View (JSON)

Overview

Supabase is a Postgres development platform that provides a managed database backend for web, mobile, and AI applications. The Table Editor is a visual interface within Supabase that allows you to manage your database schema without writing SQL. Renaming tables is a common administrative task—you might need to do this to align with naming conventions, refactor your schema, or correct a previous naming mistake. This workflow guides you through accessing the table editor, updating the table name, and persisting those changes to your database.

Before you begin

  • A Supabase account (free or paid) at supabase.com
  • An active Supabase project with at least one existing table
  • Access to the project dashboard in the Supabase console
  • Appropriate permissions to modify table schemas (typically project owner or admin role)

Step by step

1
Clickbutton

Click the button associated with the table you want to edit (such as a context menu or options button next to the table name in the sidebar or table list) to open the table's actions menu.

Tip. Look for a three-dot menu icon, gear icon, or right-click context menu next to the table name.
Step 1
2
TypeName

Type or identify the name field in preparation for editing. This step establishes focus on the Name textbox element that will receive your new table name.

Tip. The Name field is usually displayed prominently in the table editor view. Clear any existing text if you're starting fresh.
3
ClickEdit table

Click the "Edit table" menu item from the context menu or dropdown that appeared in step 1. This opens the table editor modal or sidebar where you can modify table properties.

Tip. The Edit table option is typically the first or most prominent choice in the table's context menu.
Step 3
4
ClickName

Click on the Name textbox field within the table editor to select it and position your cursor there, allowing you to enter the new table name.

Tip. Double-clicking the field may be necessary if single-click does not activate edit mode. The field should show a text cursor and highlight when active.
Step 4
5
TypeName

Type the new table name into the Name field. Replace the old name with the new name, following PostgreSQL naming conventions (use lowercase letters, numbers, and underscores; avoid starting with a number or reserved keywords).

Tip. Clear the existing text first to avoid appending to the old name. Table names are case-insensitive in PostgreSQL but are conventionally lowercase.
Warning. Changing a table name will break any application code, API endpoints, or queries that reference the old table name. Ensure you update all dependencies before saving.
6
ClickSave ⌘ ↵

Click the "Save" button (marked with ⌘ ↵ keyboard shortcut indicator) to persist your table name change to the Supabase database.

Tip. You can also use the keyboard shortcut Cmd+Enter (Mac) or Ctrl+Enter (Windows/Linux) to save without clicking the button.
Warning. Once saved, the table rename is immediate and affects all references in your database. Verify the new name is correct before saving, as you may need to update application code that queries this table.
Step 6

Confirm it worked

  1. 1The table editor modal or sidebar is visibly open with the table name field displayed
  2. 2The table name field contains your new name and is editable
  3. 3After clicking Save, a success confirmation message appears (or the editor closes without error)
  4. 4When you navigate back to the Tables list in the left sidebar, the table now appears with its new name

Common issues

Keep reading

How to Edit an Excel Table - ExcelDemy

How to Edit an Excel Table - ExcelDemy # How to Edit an Excel Table ## Edit Excel Table: Knowledge Hub - About Us - Rename a Table in Excel - Extend the Table in Excel - Mirror Table in Excel - Mak

exceldemy.com

How to Edit Table in Excel: A Step-by-Step Guide for Beginners

How to Edit Table in Excel: A Step-by-Step Guide for Beginners Editing a table in Excel might seem daunting at first, but it’s pretty straightforward. You can change the table’s structure, modify dat

supportyourtech.com

Excel Tutorial: How To Edit Data Table In Excel – DashboardsEXCEL.com

Excel Tutorial: How To Edit Data Table In Excel – DashboardsEXCEL.com # Excel Tutorial: How To Edit Data Table In Excel ## Introduction Excel data tables offer a smarter alternative to simple range

dashboardsexcel.com