Default Values

The default of defaults: NULL

Specifying default values:

CREATE TABLE Person(

name VARCHAR(30),

social-security-number INTEGER,

age SHORTINT DEFAULT 100,

city VARCHAR(30) DEFAULT “Seattle”,

gender CHAR(1) DEFAULT “?”,

Birthdate DATE