Creating tables via SQL editor in Supabase - Quick Revision & Summary

Recall & Review

beginner

What is the basic SQL command to create a new table?

The basic command is CREATE TABLE table_name (column1 datatype, column2 datatype, ...); which defines the table name and its columns with data types.

beginner

Why do we specify data types when creating a table?

Data types tell the database what kind of data each column will hold, like numbers, text, or dates. This helps keep data organized and valid.

intermediate

What does the PRIMARY KEY constraint do in a table?

It uniquely identifies each row in the table. No two rows can have the same primary key value, ensuring each record is unique.

intermediate

How can you add a column that automatically increases for each new row?

Use the SERIAL data type in Supabase SQL, like id SERIAL PRIMARY KEY, which auto-increments the value for each new record.

beginner

What is the purpose of the SQL editor in Supabase?

The SQL editor lets you write and run SQL commands directly on your database, like creating tables, inserting data, or querying information.

Which SQL command creates a new table?

A SELECT

B CREATE TABLE

C INSERT INTO

D DROP TABLE

CREATE TABLE is used to make a new table. INSERT INTO adds data, SELECT reads data, and DROP TABLE deletes a table.

What does PRIMARY KEY ensure in a table?

A Column allows null values

B Table is encrypted

C Data is sorted

D Each row is unique

The PRIMARY KEY makes sure each row has a unique identifier.

In Supabase SQL, which data type auto-increments for new rows?

A SERIAL

B DATE

C BOOLEAN

D TEXT

SERIAL automatically increases the number for each new row.

Why do we specify data types for columns?

A To speed up the internet

B To decorate the table

C To tell the database what kind of data to expect

D To change the table color

Data types help the database understand what kind of data each column holds.

What can you do with the SQL editor in Supabase?

A Write and run SQL commands

B Design website layouts

C Edit images

D Send emails

The SQL editor is for writing and running SQL commands on your database.

Explain how to create a table with an auto-incrementing primary key in Supabase SQL.

Think about how to define columns and make one column auto-increment.

Describe the role of data types when creating tables in a SQL editor.

Consider why the database needs to know what kind of data each column holds.