Indexes always descending

[olivers]

For some reason, all indexes I define get the DESC qualifier for each field when creating DDL... Only when I go to the Extended Properties dialog for each index, set to Descending and back to Ascending (to activate the Save button) and hit Save, DDL is created with ASC. Why doesn't EA simply leave out the qualifier if I didn't define one? The way it is, I'll have to work over all my indexes... :-(

[sparks]

This message was replied to via email, below is a copy of the reply.


Hello,

Currently EA is designed to generate DDL for an Index with the values that are set in the extended properties screen, however in the case where these values have not been set EA will use the default, DESC is the default sort order.  It was imagined that the extended properties of an Index would need to be reviewed for each index at creation time.  Upon further thought regarding this matter, it does make sense to include a third sort (and make it the default) option of 'None' or 'Default' which will allow the database product to decide on the sort order.

Paul Mathers