General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Alternative to packing a table
I have heard that it is not wise to pack a table on a production system, especially when you're dealing with a fairly large table. ( 100,000+ ). Instead you do something like:
PARAMETERS tcDbc, tcTableName
USE (tcTableName)
COPY TO TEMP DATABASE (tcDbc) FOR NOT DELETED()
RENAME TEMP.DBF TO &tcTableName..DBF
REINDEX
* Or recreate the indexes one by one from a data dictionary
1. Is the correct syntax.
2. If its correct, is there a problem in VFP 5, where the copy to only copies the first 10 characters of field names.
TIA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only