On May 3, 2006, at 9:25 PM, Dave Elsner wrote:
After speaking with our Oracle DBA they would like columns name for each table to be created in order of their significants when the create table statements are ran.
i.e The Primary Key(s) should be first, the candidate keys then foreign keys, then every thing else.
However the default in EOModeler is to order them alphabetically is there any way around this? So I can customize the order on a per table basis ?
Yes, there is a way around this: get a new DBA. That is a seriously silly requirement.
I would prefer not to write the SQL by hand.
If the insanity persists, hand-coding is probably your best bet. EOModeler's output is rather limited anyway, so its nice to be able to replicate all the tweaks that you may have to do in a single file.
sacha
--
Sacha Michel Mallais Senior Developer / President
PGP Key ID: 7D757B65 AIM: smallais
"Good people do not need laws to tell them to act responsibly,
while bad people will find a way around the laws." -- Plato