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