Lesson 25 of 3278%
(Progress persistence is disabled until Phase 9)
SQL
Beginner
CREATE TABLE
Define a new table.
CREATE TABLE
Define a new table.
Example
-- Create a new tags table
CREATE TABLE tags (id INTEGER PRIMARY KEY, name TEXT NOT NULL);
SELECT * FROM sqlite_master WHERE type='table';Test it Yourself