Creating Tables (CREATE TABLE, Data Types)

Before storing data, you need to create tables that define the structure of your database.

The CREATE TABLE Statement

Use CREATE TABLE followed by the table name and a list of columns with their data types.

Example:

CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT,
age INTEGER,
join_date DATE
);

Common Data Types

• INTEGER — Whole numbers
• TEXT — Strings or text
• DATE — Dates
• BOOLEAN — True/False values
• FLOAT or REAL — Decimal numbers

Primary Keys

A primary key uniquely identifies each row. It’s important for relationships and indexing.

Creating tables is the first step to organizing your data efficiently.

‍