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]

Reply via email to