CREATE TABLE MAPS2 ( MAP_ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), MAP_NAME VARCHAR(24) NOT NULL, REGION VARCHAR(26), AREA DECIMAL(8,4) NOT NULL, PHOTO_FORMAT VARCHAR(26) NOT NULL, PICTURE BLOB(102400), CONSTRAINT Map2AutoPK PRIMARY KEY (MAP_ID) ) ;
When I try to apply this to a custom example I get shut down over and over again. I cannot figure out what the problem is. Below is what I am trying.
CREATE TABLE AUTHOR ( ID INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), FIRST VARCHAR(30) NOT NULL, MIDDLE VARCHAR(30), LAST VARCHAR(30) NOT NULL, CONSTRAINT AuthorAutoPK PRIMARY KEY (ID) ) ;
The following error pops out:
ERROR 42X01: Syntax error: Encountered "FIRST" at line 5, column 1.
What in the world am I doing wrong?