CREATE TABLE
Hands-on tutorial
01 / THE CONCEPT
Understand the idea
In this lesson, explore create table. Study the SQL example, run it in the lab when applicable, and consider how it relates to real database systems.
02 / SQL EXAMPLE
◉ example.sqlSQL
CREATE TABLE products(id INTEGER PRIMARY KEY, name TEXT NOT NULL, price REAL);Try in SQL Lab ↗03 / KNOWLEDGE CHECK
Check your understanding
Which statement best describes create table?