I have several script creating tables in a database. Was ok in 200, broken in 1056/210.
a Syntax Error is thrown:
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]