All posts
SQLCREATE TABLEDDLtutorial

What is CREATE TABLE in SQL? Creating a table for beginners

CREATE TABLE is the SQL command for "create a new table". Plain words: which columns and what types, what NOT NULL, DEFAULT, PRIMARY KEY, and FOREIGN KEY do, and why thinking about the schema upfront pays off. With before/after tables, common beginner mistakes, and three exercises.

1 min readSQL · CREATE TABLE · DDL · tutorial

CREATE TABLE is the command for "give me a new table with these columns and rules". It's the first SQL on any new project — without tables, there's nothing to INSERT into and nothing to SELECT from.

This article is currently in Russian. The full English translation is on the way.

Practice on real tasks

Solve tasks in the SQL trainer with instant grading and hints.

Open trainer