Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: Jeff Odell on February 18, 2005, 10:32:24 am
-
I'm using the Oracle settings to generate DDL for an Oracle Lite database. The types are compatible so it largely works. However, there is a problem when generating the SEQUENCE DDL corresponding to marking a column Autonumber.
When you set the Autonumber property for a column, the CREATE SEQUENCE generated command is:
CREATE SEQUENCE APPLICATION_GROUP_ID_SEQ
increment by 1
start with 1
NOMAXVALUE
minvalue 1
nocycle
nocache
noorder;
Oracle Lite doesn't like the nocycle, nocache or the noorder keywords. Otherwise, it works fine. I can post process but was wondering if there was any way to suppress these, or control the DDL generation in general.
TIA -
Jeff Odell