General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Did you try? Alter should replace existing index.
>I need to affect existing indexes, not create new ones
>
>
>>Something like:
>>
>>USE databsename!tablename EXCLUSIVE
>>ALTER TABLE tablename ADD PRIMARY KEY fld1 TAG fld1
>>
>>See more on Alter Table in VFP Help.
>>
>>>Is there a way to do it?
>>>
>>>For Example:
>>>table1 has index1 and index2 (regular type)
>>>I need to change Index1 to Primary, and Index2 to Candidate
Previous
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