Controlling DDL Generation for Oracle

[Jeff Odell]

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