Advanced Oracle DDL

[Luis J. Lobo]

Hi,

Respecting to the physical model and DDL generation (Oracle):

First,

When creating a Sequence, the name is automatically assigned during the DDL generation, with the format:

TableName_ColumnName_SEQ

It could be usefull to be able to set manually the name in the "Column Properties" window of the Sequence.

Second,

The Trigger DDL generation always include the sentence "SHOW ERRORS". It should be an option.

[Luis J. Lobo]

In addition, neither I can adapt the value of the NOMAXVALUE, MINVALUE, NOCYCLE, NOCACHE and NOORDER values.

Is there any way to indicate these values? I'd tried with Tagged Values (of the Column with the sequence) but doesn't work.

Thanks,

Luis.

[«Midnight»]

Good points. Though some are Oracle-specific, there are similar settings for other engines. Some method - tags or whatever - needs to be introduced to handle these predictably, and if possible gracefully.

[Martin Terreni]

I think some of this think can be hacked with tags. I've done some hack with tag (for spesifying InnoDB I think) so maybe ther are others.
Any way, though all generic options should be added - only generic options should be added - I would like EA to turn to be an Oracle moduling tool, I need modeling tool with a module that suits all.

[Luis J. Lobo]

Thanks for the comment.

You are right, Martin, for that reason I propose to make it by means of labels better than GUI dialogs with checkboxes, options...

EA now supports some specific tags for Oracle, and this only an extension of the same philosophy. The model should be independent of the DB implementation, But not the DDL generation, which is necessarily oriented to the technology.

Regards,