Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Hi Mary-Ann.
Some ideas:
- are you sure the data in the column has no duplicates
- there might be some deleted records in the table. You must pack the table to remove. Uniqueness is enforced for deleted rows as well since they are still in the table and could possibly be "undeleted".
>trying to create a database with 2.6 tables. I'm able to put them in the container, but then if I try to change the 'main' file's index to 'Primary', I get "Uniqueness of Index IndexName is violated". I can't set up the relationships. The only way it will work is if I delete all the records. But when I do that, (obviously I'm going to need the data) and try to append from a copy to add the records back in, it stops at about a third of the way through and gives me the same "uniqueness of index" error. What am I doing wrong?
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement