SQL Fundamentals · Database Basics · Lesson 2 of 17

Creating a Table

Concept

Creating a Table

CREATE TABLE defines a table's structure: its columns, each column's data type, and constraints like PRIMARY KEY.

By the end of this lesson

Explain the core idea behind Creating a Table.
Predict output before running a change.
Test one realistic and one unusual input.
Use the result to make the next decision.

How to study this page

1. Read one concept.
2. Change the example.
3. Run, compare, and explain.
4. Complete the challenge below.

ExampleRunnable

CREATE TABLE students (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    age INT
);

Try it Yourself »

Self-check before continuing

Without looking at the example, describe what changes when you modify one input in Creating a Table. Then reopen the editor and prove your explanation with a small test.

You are ready to continue when you can predict, test, and explain the result.

Your turn

Write a CREATE TABLE statement for a courses table with id, title, and level columns.

Loading editor…

Console

Output will appear here...