- NOT NULL
- UNIQUE
- PRIMARY KEY
constraints
examples/cars.sql
CREATE TABLE car ( owner_name VARCHAR(100), color VARCHAR(20) NOT NULL, license_plate VARCHAR(20) UNIQUE, motor_number VARCHAR(20) UNIQUE NOT NULL );
examples/insert_car.sql
INSERT INTO car (owner_name, color, license_plate, motor_number) VALUES ("Foo Bar", "Blue", "12-345-67", "DFAFD3243EGGER");
examples/insert_unsold_car.sql
INSERT INTO car (color, motor_number) VALUES ("Yellow", "GFAFD3243EGGER");
examples/insert_another_unsold_car.sql
INSERT INTO car (color, motor_number) VALUES ("White", "GFAFD3243EGGER");