You can specify a column as either INT or IDENTITY but not both. On Wed, 2 Feb 2022 at 20:38, Helmut Leininger <[email protected]> wrote:
> This was not the case in 200 > > Syntax error in SQL statement "create table persons (mstb_per_no int > [*]identity not null, mstb_father int, mstb_mother int, mstb_last_edit > date, mstb_dsid int, mstb_ref_id int, mstb_reference varchar(12), > mstb_spoulast int, mstb_scbuff varchar(10), mstb_pbirth varchar(30), > mstb_pdeath varchar(30), mstb_relate int, mstb_relatefo int, mstb_tt > varchar(1), mstb_sex varchar(1), mstb_living varchar(1), mstb_birthorder > varchar(2), mstb_multibirth varchar(1), mstb_adopted varchar(1), > mstb_ance_int varchar(1), mstb_desc_int varchar(1))"; expected "ARRAY, > INVISIBLE, VISIBLE, NOT, NULL, AS, DEFAULT, GENERATED, ON, NOT, NULL, > AUTO_INCREMENT, DEFAULT, NULL_TO_DEFAULT, SEQUENCE, SELECTIVITY, COMMENT, > CONSTRAINT, COMMENT, PRIMARY, UNIQUE, NOT, NULL, CHECK, REFERENCES, > AUTO_INCREMENT, ,, )"; SQL statement: > > create table persons (mstb_per_no int identity not null, mstb_father int, > mstb_mother int, mstb_last_edit date, mstb_dsid int, mstb_ref_id int, > mstb_reference varchar(12), mstb_spoulast int, mstb_scbuff varchar(10), > mstb_pbirth varchar(30), mstb_pdeath varchar(30), mstb_relate int, > mstb_relatefo int, mstb_tt varchar(1), mstb_sex varchar(1), mstb_living > varchar(1), mstb_birthorder varchar(2), mstb_multibirth varchar(1), > mstb_adopted varchar(1), mstb_ance_int varchar(1), mstb_desc_int > varchar(1)) [42001-210] > > Sorry for possible double posting (this is my first try in this group) > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/h2-database/f64c2b8d-9e77-4d40-acc5-649a5ebdf311n%40googlegroups.com > <https://groups.google.com/d/msgid/h2-database/f64c2b8d-9e77-4d40-acc5-649a5ebdf311n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/CAFYHVnUyL7FpEEWDD%3Dn0E0xC1V34ebtXgLn%2BL6R71whw%3DZPsvg%40mail.gmail.com.
