Revisions to How to use default value of data type as column default?

deleted 11 characters in body

edited Aug 14, 2021 at 8:34

You should specify what is the default. If I remember correctly the default constraintDEFAULT 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 );

You should specify what is the default. If I remember correctly the default constraint 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 );

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 );

adapt to adapted question

edited Jul 15, 2018 at 14:05

You should specify what is the default. If I remember correctly the default constraint 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 );

I also removed the quotes "".

You should specify what is the default. If I remember correctly the default constraint 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 );

I also removed the quotes "".

You should specify what is the default. If I remember correctly the default constraint 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 );

answered Jul 15, 2018 at 12:18

You should specify what is the default. If I remember correctly the default constraint 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 );

I also removed the quotes "".

Return to Answer