Creating tables via SQL editor in Supabase - Visual Walkthrough

Process Flow - Creating tables via SQL editor

Open SQL Editor

↓

Write CREATE TABLE statement

↓

Run the SQL command

↓

Database processes command

↓

Table created in database

↓

Verify table exists

↓

END

This flow shows how you open the SQL editor, write a CREATE TABLE command, run it, and the database creates the table.

Execution Sample

Supabase

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  name VARCHAR(100),
  email VARCHAR(100) UNIQUE
);

This SQL command creates a 'users' table with id, name, and email columns.

Process Table

Step	Action	SQL Command	Database Response	Result
1	Open SQL editor		SQL editor ready	Ready to write SQL
2	Write CREATE TABLE	CREATE TABLE users (id SERIAL PRIMARY KEY, name VARCHAR(100), email VARCHAR(100) UNIQUE);	SQL command entered	Command ready to run
3	Run SQL command	CREATE TABLE users (id SERIAL PRIMARY KEY, name VARCHAR(100), email VARCHAR(100) UNIQUE);	Command executed successfully	Table 'users' created
4	Verify table	SELECT * FROM users;	Empty result set	Table exists and is empty

💡 Table 'users' created successfully and verified by empty SELECT query

Status Tracker

Variable	Start	After Step 2	After Step 3	After Step 4
SQL Editor State	Closed	Open with command typed	Command executed	Table verified
Table 'users' Exists	No	No	Yes	Yes
Table 'users' Rows	N/A	N/A	0	0

Key Moments - 3 Insights

Why does the table not show any rows immediately after creation?

Because the table is just created and no data has been inserted yet, as shown in execution_table step 4 where SELECT returns empty.

What happens if you run the CREATE TABLE command twice without changes?

The database will return an error because the table already exists. This is not shown in the current execution but is important to avoid.

Why do we use SERIAL for the id column?

SERIAL automatically creates a unique number for each new row, acting as a primary key, ensuring each row can be uniquely identified.

Visual Quiz - 3 Questions

Look at the execution table, what is the database response after running the CREATE TABLE command?

A Empty result set

B SQL editor ready

C Command executed successfully

D Command entered but not run

💡 Hint

Check the 'Database Response' column at Step 3 in the execution_table

At which step does the table 'users' first exist in the database?

A Step 1

B Step 3

C Step 2

D Step 4

💡 Hint

Look at the 'Result' column in execution_table where the table creation is confirmed

If you add a new column after creation, how would the execution table change?

A A new step with ALTER TABLE command and success response

B The table would be created twice

C The SQL editor would close automatically

D The table would be deleted

💡 Hint

Think about how SQL commands modify tables after creation, not shown but logically following the flow

Concept Snapshot

CREATE TABLE syntax:
CREATE TABLE table_name (
  column_name data_type constraints,
  ...
);

Run this in SQL editor to create a new table.
Use SERIAL for auto-increment IDs.
Verify creation with SELECT query.

Full Transcript

To create a table using the SQL editor, first open the editor. Then write a CREATE TABLE statement defining the table name and columns with their data types and constraints. Run the command. The database processes it and creates the table. You can verify the table exists by running a SELECT query which will show no rows initially since the table is empty. The id column often uses SERIAL to auto-generate unique IDs. Running the CREATE TABLE command twice without changes causes an error because the table already exists.