Changing the Indexed property of a field in a table

[stealth3]

Dear Team

I have inherited a poorly designed database and one of the problems is that a field has been set up as Indexed - Yes (No Duplicates) when (Yes Duplicates) should have been selected. This table only has an ID field and one other text field which is the primary key and is the one I want to change. To change it requires removing it as the primary key, removing the relationship and then re-establishing. However I am having problems doing this and I am wary that the data in the db will be permanently affected. Can anyone advise if this is so?

Regards

 

[Trevil]

You can safely remove / alter indices, but I would suggest doing it when you have exclusive use of the database.

You will need to remove the relationship BEFORE you remove the index. If needed, I have some code laying around.


Learn from the mistakes of others. You won't live long enough to make all of them yourself.