Manage Tables

Create, rename, and delete PostgreSQL tables from Fakebase Studio.

Creating and managing tables in Fakebase Studio

Open Tables in the sidebar to see every table in the connected database. Search or filter by schema, then select a table to work with it.

You can do the same work in the SQL editor. The examples below use a sample orders table.

Create a table

Open Tables.
Choose New table (or ⌘N).
Enter a name, optional description, and columns.
Confirm. Fakebase creates the table in the public schema.

New tables are created in public. Switch the schema filter to browse tables in other schemas.

CREATE TABLE public.orders (
  id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
  created_at timestamptz NOT NULL DEFAULT now(),
  email text NOT NULL,
  total numeric(10, 2) NOT NULL DEFAULT 0
);

Rename or delete a table

Open the table row menu (⋮) or right-click a table:

Change table name — renames the table. Rows, indexes, and constraints stay.
Delete table — permanently removes the table and its data.

The _fakebase_migrations table is protected and cannot be renamed or deleted.

ALTER TABLE public.orders RENAME TO shop_orders;

DROP TABLE public.shop_orders;

Create a table

Rename or delete a table

Related