Index does not survive table drop or column drop that involves index. I will add test for this too.