Create a Table

Time to build your own world! In this lesson, you’ll create your first SQL table—a place to store structured data.

Goal

You’ll aim to:

• Use CREATE TABLE to define a table.

• Set column names and types.

• Understand table schemas.

Basic table creation

This table will have four columns, each with a specific data type: