create table FOO ( ID integer generated by default as identity(start with 1), NAME varchar(255) not null, constraint FOO_PK primary key(ID) );