Indexed fields

[Stephanie]

I have a table with three fields that are marked as indexed fields with unique keys. I want
to remove one of the fields. When I do this and hit the rebuild button -- I get an error, that
there is a duplicate field, so it will not just let me remove the one field and leave the other
two?? How can I get around this?

[richard]

It sounds like there may be a table formating issue that needs to be taken into account. Post the table statistics and I'll have a look at it for you.


------------
Stephanie at 6/22/00 11:31:22 PM

I have a table with three fields that are marked as indexed fields with unique keys. I want
to remove one of the fields. When I do this and hit the rebuild button -- I get an error, that
there is a duplicate field, so it will not just let me remove the one field and leave the other
two?? How can I get around this?

[Andy H]

Stephanie

I assume that the fields are all part of the same unique index and you wish to remove one. In this case, you are getting a failure because the combination of the data in the remaining 2 fields is no longer unique

eg (a,b,c) => (a,b)
(a,b,d) => (a,b)

The only way around this is to rebuild the index as non-unique with the two fields required.
You should also bear in mind though, that this may be a unique combination to enforce integrity within the data and you would then be removing the enforcement mechanism

Hope this helps
Andy H


------------
Stephanie at 6/22/00 11:31:22 PM

I have a table with three fields that are marked as indexed fields with unique keys. I want
to remove one of the fields. When I do this and hit the rebuild button -- I get an error, that
there is a duplicate field, so it will not just let me remove the one field and leave the other
two?? How can I get around this?