>I have what is apparently an invalid database. Among the problems, some of the tables have an "Invalid primary key property." When I try to open the table, or alter it, I get an error telling me "Primary key property is invalid; please validate database." Issuing a VALIDATE DATABASE merely lists the problems, it doesn't solve them. How can I fix the primary key problem? Also, I need to be able to do it programmatically at a client's site.
>
I'd strongly recommend using a third party product for validation and repair - I've had great success with Stonefield Database Toolkit, both as a means of repairing and reviewing the status of a database, and as a means of propagating changes to various structures in a database using metadata.