lab learn how databases change · 22 experiments · resets every run

Create a table

Define a table with typed columns and a primary key.

what to run

Run the script as written. It creates notes, then reads the table definition back from sqlite_master.

what you should see

The result shows the notes table name and its CREATE TABLE definition, including the primary key and required body.

how the lab works

Every run starts from a fresh temporary copy of the sample database, so tables you create and rows you change are not kept between runs. Your SQL is saved in this browser. End a script with a SELECT to see what changed.