Tous les articles
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 de lectureSQL · 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.

Entraînez-vous sur de vrais exercices

Résolvez des exercices dans l'entraîneur SQL avec évaluation et indices instantanés.

Ouvrir l'entraîneur