Welcome back

Sign in with GitHub, Google, or your email and password

or

Don't have an account? Create one

Manage Tables

Relations

View and manage foreign-key relationships between tables in Fakebase Studio.

Open a table and choose the Relationships tab to see foreign keys from and to that table.

View relationships

The tab is a map of the current table:

  • References to other tables — outgoing foreign keys
  • Referenced by — incoming foreign keys from other tables

Use this view to understand how tables connect. Adding or removing a relation happens from the column editor.

Add a foreign key

  1. Open the table and go to Columns.
  2. Add or edit a column, then choose Add foreign key.
  3. Pick the referenced schema, table, and column pairs.
  4. Choose what happens if the referenced row is updated or removed.
  5. Save.

You can also add a foreign key while creating a new table.

Remove a foreign key

Edit the column that owns the relation and remove the foreign key from the Foreign Keys list.

Manage TablesCreate, rename, and delete PostgreSQL tables from Fakebase Studio.Manage columnsAdd, update, and remove columns on a PostgreSQL table in Fakebase Studio.SchemaExplore your database schema as an interactive diagram in Fakebase.