Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Delete IDX accidentally |
Mon, May 12 2008 2:40 PM | Permanent Link |
"Jose Eduardo Helminsky" | Tim
In my tests I accidentally delete an index file (Table.EDBIdx) and I have realized it has created again when I opened the table ? ElevateDB lookup the catalog and check it every open ? Eduardo |
Tue, May 13 2008 3:19 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Jose
Its even better than that - delete the three files making up the table and they will be recreated (blank) when you next open that database. Its a benefit of storing the metadata in the catalog rather than the table. Mind you if you blow the catalog away you're really stuffed Roy Lambert [Team Elevate] |
Tue, May 13 2008 6:01 AM | Permanent Link |
"Jose Eduardo Helminsky" | Roy
Thanks Eduardo |
Tue, May 13 2008 11:35 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Eduardo,
<< In my tests I accidentally delete an index file (Table.EDBIdx) and I have realized it has created again when I opened the table ? ElevateDB lookup the catalog and check it every open ? >> Just a quick clarification - the index file will be recreated, but it won't be populated if there are rows in the table. You'll have to use the REPAIR TABLE statement to repair the table in such a case. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, May 13 2008 12:09 PM | Permanent Link |
"Jose Eduardo Helminsky" | Tim
Got it. Eduardo |
This web page was last updated on Monday, April 29, 2024 at 05:23 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |