Book a Demo

Author Topic: SQL Server Index not Generated  (Read 2649 times)

Jeff Odell

  • EA User
  • **
  • Posts: 99
  • Karma: +0/-0
    • View Profile
SQL Server Index not Generated
« on: July 13, 2004, 05:21:09 am »
While designing a table in a SQL Server 2000 data model, I added an alternate key index on two fields in the table using the Operations dialog.

The Index shows up on the diagram and in the Project View as expected.  In the Operations dialog, the stereotype is index and the two columns are specified.

When I generate DDL, this index is consistently ignored.  I'm checking the Generate Index/Constraints checkbox.  I've tried the same on another table with the same result.

I'm using 4.10.731.  Has anyone else experienced this problem?

hd

  • EA Administrator
  • EA User
  • *****
  • Posts: 312
  • Karma: +0/-0
    • View Profile
Re: SQL Server Index not Generated
« Reply #1 on: July 13, 2004, 03:40:45 pm »
Seems to be a bug  :-[. We will attend to this ASAP.

Jeff Odell

  • EA User
  • **
  • Posts: 99
  • Karma: +0/-0
    • View Profile
Re: SQL Server Index not Generated
« Reply #2 on: July 13, 2004, 09:05:02 pm »
Thanks for the update.  I'll hold on for a bug fix.

jlo