Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting indexes
Message
From
07/07/2000 16:15:21
Jonathan Cochran
Alion Science and Technology
Maryland, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00389651
Message ID:
00389662
Views:
17
There is an ALTER TABLE command that will let you create a primary key.

>I have a form that inserts a couple of million records into a table from a text file. This process seems to get slower and slower the longer it runs.
>
>I would like to delete the indexes on this table before reading in the data. Hopefully this will speed thinks up.
>
>I found the delete tag command that actually deletes the cdx file. Is there a way to recreate these indexes programmatically when everything is done. I looked at the index command, but I don't think this will work because I need on of the indexes to be primary.
>
>Is there another way to do this?
>
>Thanks
>
>Pat Murphy
Previous
Reply
Map
View

Click here to load this message in the networking platform