Create AutoIncrement column in Apache Derby

CREATE TABLE students

(

id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),

name VARCHAR(24) NOT NULL,

address VARCHAR(1024),

CONSTRAINT primary_key PRIMARY KEY (id)

) ;




The value of an autoincrement column increments automatically with every insert and doesnt need to be specified in the insert command. It is 1 + the value of the same field in the previous row.