Book a Demo

Author Topic: DDL Field Order  (Read 2382 times)

DevilDog74

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
DDL Field Order
« on: May 26, 2006, 05:41:17 am »
I have created a table using EA 6.1.785.  Fields shown in the table on the diagram are in alphabetical order, not the order that I put them in using the property editor.  Also, when creating the DDL for the table, the fields are put in alphabetical order.

Is there a way to ensure that the fields are put into the DDL script in the order that they are entered and NOT alphabetical order?

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: DDL Field Order
« Reply #1 on: May 26, 2006, 05:59:23 am »
Open the Tools / Options dialog and choose the Objects page. At the bottom of the left-hand column of check boxes, clear Sort Features Alphabetically. This affects all structural elements, including tables (which are stereotyped classes).

You may wan to experiment with the two buttons at the bottom of the right-hand column. Check the results closely, since these can have visible effects on data diagrams.

HTH,
David
No, you can't have it!

DevilDog74

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: DDL Field Order
« Reply #2 on: May 26, 2006, 07:40:06 am »
Cool, thanks for the reply.