Some other things that would be nice to have.
1) The ability to specify tablespace for foreign key indexes. In the real world you typically seperate tables and indexes into seperate tablespaces.
Current DDL Generated:
------------------------------
ALTER TABLE ADVODM_DEADLINE_MANAGER ADD CONSTRAINT ADM_PK
PRIMARY KEY (DEADLINE_MANAGER_ID)
;
Desired With USING INDEX clause:
------------------------------------------
ALTER TABLE ADVODM_DEADLINE_MANAGER ADD CONSTRAINT ADM_PK
PRIMARY KEY (DEADLINE_MANAGER_ID)
USING INDEX TABLESPACE <INDEX_TABLESPACE>
;
2) When specifying a column as autonumber, I'd like to be able to change the name for the SEQUENCE it generates.
Right now it creates some funky names for sequences.
DROP SEQUENCE ADVODM_DEADLI_DEADLINE_MAN_SEQ;
A common convention is "<TABLE_NAME>_S".
At the moment, every time I generate, I have to go back and edit the source manually.
3) Can't seem to figure out how to create additional indexes. Help file talks about adding an operation and stereo typing to INDEX, which is fine, but THEN you cannot select any columns other than the primary or foreign key columns. I should be able to select other columns from the table, including multiple columns to create a concatenated index. (Also Specifying tablespace would be usefull).
I work as a consultant, and would like to recommend EA as an alternative to Oracle Designer for data modelling, since it offers so much more. With a little bit of tweaking it would be there.
Todd
