DROP TABLE db2admin.comments;
CREATE TABLE db2admin.comments (
id INT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
user VARCHAR(30) NOT NULL,
email VARCHAR(30),
commentdate DATE NOT NULL,
comment VARCHAR(400) NOT NULL,
PRIMARY KEY (id)
);
/*
INSERT INTO db2admin.comments (user,email, commentdate, comment)
VALUES('Bob', 'bob@mail.com', '2019-02-19', 'Very comprehensive and well developed book!');
DELETE FROM db2admin.comments;
*/