0PricingLogin
Supabase Backend as a Service · Lesson

Creating Tables and Columns

Hands-on experience creating new tables, defining column types, setting primary keys, and adding foreign key constraints directly in Supabase.

Building Blocks of Your Data

Welcome to creating your first database! Just like organizing information in a spreadsheet, databases use tables to hold related data.

Think of a table as a single sheet in your spreadsheet. Each table has columns, which are like the headings, defining what kind of information each entry will hold.

Into the Supabase Studio

Supabase provides a powerful web interface called the Supabase Studio (or Dashboard) to manage your project. This is where we'll create our tables.

  • First, log in to your Supabase project.
  • On the left sidebar, click the Database icon (it looks like a cylinder).
  • Then, select Table Editor from the submenu.

All lessons in this course

  1. Designing Database Schemas
  2. Creating Tables and Columns
  3. Basic Data Insertion & Querying
  4. Relationships and Foreign Keys
← Back to Supabase Backend as a Service