What if I'm so anal retentive that I want to keep my tables sorted in certain ways?
In 2.11 I simply ran a file that RENAMEd each table to Temp and PROJECTed a new, sorted table from Temp. Then I REMOVEd TABLE Temp and moved on to the next table. After all the sorted tables were projected, my file would BUILD KEY for each appropriate column in each appropriate table. A PACK or RELOAD removed the wasted space. But things have changed... PKs and other Restraints prohibit this naive approach. I don't even want to get into the errors I get. I want a single control file that sorts my tables and preserves / restores my Keys and Restraints. Doesn't seem all that unusual. How do I do it? Thanks, Fred Fred C. Kopp Authorized R:Base Developer 19 Teri Lane Washington, PA 15301 P 724-222-7376 F 724-222-7376 C 724-413-5534 E [EMAIL PROTECTED]

