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.
