Dropping indexes and updating ddfs PSQL v10.10
Dropping indexes and updating ddfs PSQL v10.10
(OP)
I needed to drop some indexes from two tables to accomodate MS Access' index restrictions. I did this via the PSQL - Utilities - Maintenance (aka Btrieve Maintenance Utility). Now I'd like to save these changes to the ddfs. A few years ago when I did this in v8 or 9, it was a simple save and update or recreate. From the BMU or the PCC, I can't see where to do this in v10.10. I'd appreciate your guidance in this matter.
Thank you!!
Thank you!!
RE: Dropping indexes and updating ddfs PSQL v10.10
DROP INDEX <index name> IN DICTIONARY
This will remove the indexes from the DDFs but not the data files (since there aren't any on the data files).
The DROP INDEX is a standard SQL statement so you'd connect through PCC and open a new SQL document (like you were going to SELECT data and just run the DROP INDEX instead).
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Dropping indexes and updating ddfs PSQL v10.10