Greetings,

 I've got a problem with a table I created in DDF builder from and existing file (PSQL ver 9.5).  The PrimaryKey index should be Zero (first key in that table).  Some how DDF builder is show it as Index 7.  A check table command shows several Index Number Mismatches.

 Is there an ALTER statement or something that I can do to correct this problem (short of retyping in the entire definition?)  Is there a utility that will let me export the ddf definition, correct it and re-import it?

 Thanks in advance!
Brent

The SQL Engine tries to match up index definitions with existing keys in the data file, but if it doesn't perceive a match, it creates the index with an available number.  The best way I found to fix this all up is to use PCC to drop all the index definitions for the table - just in the DDFs - using statements like:
    DROP INDEX table.index_name IN DICTIONARY

Then, open the table in DDFBuilder and let it add the index definitions back in.  It should figure out all the correct attributes.

 Before doing anything, make a backup of your DDFs...

Thank you...that strategy worked perfectly.