WOW!
That's quite a list of things to do!
I had no idea. Is all of that really necessary? I just want to get rid of my indexes and create them from scratch. I never heard of "the zero bit on the 28th byte of the table header" let alone clearing it...
And I never heard of "the binary memos in the dbc."
And at this time, I wouldn't know what to do with them if I did.
---------------------------------
>>Does anyone know how to remove DBC Relations? (in program code)
>>Also,
>>Does anyone know how to set DBC Relations? (in program code)
>>
>>I would like to add a reindex program to my app... but the way I'm doing it requires that I remove the relations first... and add them back in later.
>
>The code to remove the relation:
>
ALTER TABLE 'tableNameHere' DROP FOREIGN KEY TAG tagNameHere
>
>To add a relation:
>
ALTER TABLE 'tableNameHere' ;
> ADD FOREIGN KEY TAG tagNameHere ;
> REFERENCES parentTableHere TAG parentPrimaryKeyTagHere
>
>
>You'll have to create all the primary keys separately (the syntax is not exactly the same as for Index On... Tag), and I assume you're destroying the .cdx files and clearing the zero bit on the 28th byte of the table header, and are also removing the primary key entries from the binary memos in the dbc.
>
>You also need to take care that all the primary keys are created before you start adding relations. Obviously, I already have a generator which does this all :).