Unless you drop a field that is used in a index, you will not lose the index.

HTH

>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?