You should specify what is the default. If I remember correctly the DEFAULT should be before NOT NULL: CREATE TABLE test ( col_1 CHAR(12) NOT NULL, col_2 INTEGER DEFAULT 0 NOT NULL, col_3 CHAR(12) DEFAULT '' NOT NULL );