Kbase P37746: Can I delete a table with duplicate keys or records?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/01/2005 |
|
Status: Unverified
GOAL:
Can I delete a table with duplicate keys or records?
FIX:
Dropping a table that contains duplicate keys or records (for example by using data dictionary) will result in a database corruption.
A dbanalysis will show that the duplicate keys have not physically deleted and it is also impossible to delete them using an idxfix .
So in order to delete a table with duplicate keys or records, first delete all the duplicate records and after drop the table.