Code Editor

Query Results

Run a query to see results.

Database Schema

Schema undefined.
Learn
Manipulation

Create

CREATE TABLE celebs (id INTEGER, name TEXT, age INTEGER);

This CREATE statement creates a new table in the database named celebs. You can use the CREATE statement anytime you want to create a new table from scratch.

1. CREATE TABLE is a clause that tells SQL you want to create a new table.
2. celebs is the name of the table.
3. (id INTEGER, name TEXT, age INTEGER) is a list of parameters defining each column in the table and its data type.

  • id is the first column in the table. It stores values of data type INTEGER
  • name is the second column in the table. It stores values of data type TEXT
  • age is the third column in the table. It stores values of data type INTEGER
Report a Bug
If you see a bug or any other issue with this page, please report it here.