I dont mind the PK thing, I prefer it that way, but it also inconsistently places migrated foreign keys on the bottom (this is just mdoeling, no reverse engineering). This is just a slight pain for us as we have a bunch of auditing fields that I like to be last for readability. Sometimes I can move them, soemtimes I can't.
Hannah > -----Original Message----- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Koivu, Lisa" ><[EMAIL PROTECTED]> > Sent: Wednesday, May 01, 2002 6:32 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ERD generation tool > > I have seen it create two columns with the exact same name in a table. It > did this by putting double quotes around the column it was adding (that > actually already existed.) > > What's so bad about moving the pk fields to the top? Why would you put them > in the middle of the table? I think having pk at the top is more readable, > and it assists with more optimal storage at a very low level. > > Lisa Koivu > Oracle Database Administrator > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).