Introduction
Creating Tables
Syntax:
CREATE TABLE students (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
city TEXT,
marks INTEGER DEFAULT 0,
joined DATE
);| Data type | Stores |
|---|---|
INTEGER / INT | Whole numbers |
DECIMAL(10, 2) | Exact decimals, e.g. money |
TEXT / VARCHAR(100) | Text |
DATE / TIMESTAMP | Dates and times |
BOOLEAN | True / false |
| Constraint | Meaning |
|---|---|
PRIMARY KEY | Uniquely identifies each row |
NOT NULL | Must have a value |
UNIQUE | No two rows can share the value |
DEFAULT | Value used if none is given |
FOREIGN KEY | Must match an id in another table |