General information
Category:
Coding, syntax & commands
>Hi all,
>
>I have to do an Alter Table command on an indexed table. Am I loosing the index when I do that? And if so, how can I avoid it?
>
>Greetings in Advance,
>
>Ron
No, you won't lose the index (whether a tag or an index file), unless you delete a column involved with the index expression.
If you alter a column type or rename the column , you will also lose a index which uses the column in it's expression.
Lennert
Previous
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