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
- Designing Database Schemas
- Creating Tables and Columns
- Basic Data Insertion & Querying
- Relationships and Foreign Keys