What happens to non-clustered indexes when the table structure changes

Ever wondered?
I have. Found this well written Paul S. Randal article which you can find over here
Hope it answers your questions like it did mine.